How to parse hierarchical data in Golang?

Question

Oracle

Hello comrades! Please help me to solve the problem. Oracle
database has a table with the following structure:

| organization_id | ogranization_name | parent_id | level |
|-----------------|-------------------|-----------|-------|
| 1               | Facebook          |           | 0     |
| 2               | Instagram         | 1         | 1     |
| 3               | Whatsapp          | 1         | 1     |
| 4               | Dynamic           | 2         | 2     |
| 5               | Google            |           | 0     |

This table shows the structure of storing hierarchical data. In my case, this is a hierarchy of organizations.
I have a question, how do you normally parse data in a Golang application to get a JSON tree structure as a response:

[
    {
        "organization_id": 1
        "ogranization_name": "Facebook",
        "childs": [
            {
                "organization_id": 2,
                "ogranization_name": "Instagram",
                "childs": null
            },
            {
                "organization_id": 3,
                "ogranization_name": "Whatsapp",
                "childs": [
                    {
                        "organization_id": 4,
                        "ogranization_name": "Dynamic",
                        "childs": null
                    }
                ]
            }
        ]
    },
    {
        "organization_id": 5
        "ogranization_name": "Google",
        "childs": null
    }
]

Are there packages for this purpose? Are there any best practices that you know about and have applied?

Answer 1

Ready packages? Yes, encoding/json. Hierarchical structures are the same as regular ones.
https://play.golang.org/p/SUE3lLBciMQ
PS The JSON you provided is invalid. There are two commas missing.