如何显示多级一对多关系树

Question

How to loop all records and display all the respective children using HTML <ul></ul>? I tried using PHP Do While but stuck at only 1 level.

MySQL (select * from user)

Desired output

Tree View

List View

Answer 1

The easy was is to do that with the help of array. Hope it helps.

$data = array();
foreach ($result as $item) {
    $key = $item['name']; // or $item['info_id']
    if (!isset($data[$key])) {
        $data[$key] = array();
    }

    $data[$key][] = $item;
}