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
)
)
)
)