how many statements are queried in medoo for example:

query classification category table:

cateid-name-parentid
1-clothes-0
2-shoes-0
3-short sleeves-1

query output classification + subclassification (only secondary, according to parentid output), want to get such a structure

array[
    ("cateid":"1","parentid":"0","name":"",
        "child":[
           ("cateid":"3","parentid":"1","name":"")
        ]
    ),
    ("cateid":"2","parentid":"0","name":"","child":[])
]

ask medoo how to cycle through the query and subquery