天天看點

mysql 父子維_MYSQL父子表相同;PHP将父級中的子級嵌套為多元數組

MYSQL傳回一個數組,如下所示。我正在使用列:“ 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

)

)

)

)