php - How to recursively get all comments of an article? ? ?

Question

Table structure: comment_id comment Idarc_id article IDcontent content parent_id comment parent node I want to get such a data structure recursively: $arr=array({code...})

欧阳克 · Answer

First take out a two-dimensional array, each item has comment_id and parent_id fields
Then use the following function to convert the above two-dimensional array into a tree structure:

 1, 'parent_id' => 0],
    ['comment_id' => 2, 'parent_id' => 0],
    ['comment_id' => 3, 'parent_id' => 2],
    ['comment_id' => 4, 'parent_id' => 1],
    ['comment_id' => 5, 'parent_id' => 4],
    ['comment_id' => 6, 'parent_id' => 4],
];

function getTree($arr = []) {
    $a = array_column($a, NULL, 'comment_id');
    $tree = [];

    foreach($a as $i => &$v) {
        if(isset($items[$item['parent_id']])){
            $items[$item['parent_id']]['children'][] = &$items[$item['comment_id']];
        } else {
            $tree[] = &$items[$item['id']];
        }
    }

    return $tree;
}