I have table like this

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?