以数组形式处理对商品的无限极回复

 

public function test()
    {
        $array = Db::name('goods_comment')
            ->where('goods_id',1)
            ->select()->toArray();
        $list = $this->generateTree($array);
        dump($list);
    }

    public function generateTree($array){
        $items = array();
        foreach($array as $value){
            $items[$value['id']] = $value;
        }
        $tree = array();
        foreach($items as $key => $value){
            if(isset($items[$value['parent_id']])){
                $items[$value['parent_id']]['son'][] = &$items[$key];
            }else{
                $tree[] = &$items[$key];
            }
        }
        return $tree;
    }

数据库结构

查询数据结构