您需要mysql不支持的递归联接。您唯一可以做的就是确定最大深度（由于p-> c，所以我将其设置为1），并以此确定所需的联接数：
最大深度=自连接数 ：
SELECt p.id as parent_id, p.name as parent_id, c1.id as child_id, c1.name as child_nameFROM my_table pLEFT JOIN my_table c1 ON c1.parent = p.idWHERe p.parent=0
例如，如果最大深度为3，则需要3个自联接：
SELECt p.id as parent_id, p.name as parent_id, c1.id as child_id_1, c1.name as child_name_1, c2.id as child_id_2, c2.name as child_name_2, c3.id as child_id_3, c3.name as child_name_3FROM my_table pLEFT JOIN my_table c1 ON c1.parent = p.idLEFT JOIN my_table c2 ON c2.parent = c1.idLEFT JOIN my_table c3 ON c3.parent = c2.idWHERe p.parent=0
