mysql 父子维,MYSQL父子相同表; PHP将父母中的孩子视为多维数组

MYSQL返回一个数组,如下所示.我正在使用column：’id_parent’来自我引用表来创建层次结构.因此,’id’为2的条目可以是’id_parent’为2的任何条目的父级,依此类推.

Array

(

[1] => Array

(

[id] => 2

[name] => About

[id_parent] => NULL

)

[2] => Array

(

[id] => 4

[name] => About Child

[id_parent] => 2

)

[3] => Array

(

[id] => 5

[name] => About Child's Child

[id_parent] => 4

)

)

如何将子项嵌套到父数组中的数组中

Array

(

[1] => Array

(

[id] => 2

[name] => About

[id_parent] =>

[children] => Array

(

[id] => 4

[name] => About Child

[id_parent] => 2

[children] => Array

(

[id] => 5

[name] => About Child's Child

[id_parent] => 4

)

)

)

)