I have table like this
| Name | Code |
|---|---|
| John | 0 |
| Sam | 01 |
| Jack | 011 |
| Bill | 02 |
| Parent | 1 |
| Some1 | 11 |
| Some2 | 111 |
| Some3 | 112 |
| Some4 | 1111 |
Is that posible group data in SQL like this?
[
{
Name: 'John',
Code: '0',
children: [
{
Name: 'Sam',
Code: '01',
children: [
{ Name: 'Jack', Code: '011' }
]
},
{
Name: 'Bill',
Code: '02'
}
]
},
{
Name: 'Parent',
Code: '1',
children: [
{
Name: 'Some1',
Code: '11',
children: [
{
Name: 'Some2',
Code: '111',
children: [
{ Name: 'Some4', Colde: '1111' }
]
},
{ Name: 'Some3', Code: '112' }
],
},
]
}
]
Or is it better to do it on JS?