array(size=5)0=>array(size=7)'id'=> int 5'pid'=> int 3'name'=> string '怎么续费'(length=12)'en_name'=> string ''(length=0)'kr_name'=> string ''(length=0)'sort'=> int 12'status'=> int 01=>array(size=7)'id'=> int 4'pid'=> int 3'name'=> string '怎么购买'(length=12)'en_name'=> string ''(length=0)'kr_name'=> string ''(length=0)'sort'=> int 11'status'=> int 02=>array(size=7)'id'=> int 1'pid'=> int 0'name'=> string '新手入门'(length=12)'en_name'=> string ''(length=0)'kr_name'=> string ''(length=0)'sort'=> int 10'status'=> int 03=>array(size=7)'id'=> int 2'pid'=> int 0'name'=> string '功能介绍'(length=12)'en_name'=> string ''(length=0)'kr_name'=> string ''(length=0)'sort'=> int 9'status'=> int 04=>array(size=7)'id'=> int 3'pid'=> int 0'name'=> string '常见问题'(length=12)'en_name'=> string ''(length=0)'kr_name'=> string ''(length=0)'sort'=> int 8'status'=> int 0
$list=>SELECT*FROM t_dict_help WHERE `status`=0GROUPBY `sort` DESCfunctionlist_to_tree($list,$pk='id',$pid='pid',$child='class_child',$root=0){// 创建Tree$tree=array();if(is_array($list)){// 创建基于主键的数组引用$refer=array();foreach($listas$key=>$data){$refer[$data[$pk]]=&$list[$key];}foreach($listas$key1=>$data1){// 判断是否存在parent$parentId=$data1[$pid];if($parentId==$root){$tree[$data1[$pk]]=&$list[$key1];}else{if(isset($refer[$parentId])){$parent=&$refer[$parentId];$parent[$child][]=&$list[$key1];}}}}return$tree;}
3, 结果
array(size=3)1=>array(size=7)'id'=> int 1'pid'=> int 0'name'=> string '新手入门'(length=12)'en_name'=> string ''(length=0)'kr_name'=> string ''(length=0)'sort'=> int 10'status'=> int 02=>array(size=7)'id'=> int 2'pid'=> int 0'name'=> string '功能介绍'(length=12)'en_name'=> string ''(length=0)'kr_name'=> string ''(length=0)'sort'=> int 9'status'=> int 03=>array(size=8)'id'=> int 3'pid'=> int 0'name'=> string '常见问题'(length=12)'en_name'=> string ''(length=0)'kr_name'=> string ''(length=0)'sort'=> int 8'status'=> int 0'class_child'=>array(size=2)0=>array(size=7)'id'=> int 5'pid'=> int 3'name'=> string '怎么续费'(length=12)'en_name'=> string ''(length=0)'kr_name'=> string ''(length=0)'sort'=> int 12'status'=> int 01=>array(size=7)'id'=> int 4'pid'=> int 3'name'=> string '怎么购买'(length=12)'en_name'=> string ''(length=0)'kr_name'=> string ''(length=0)'sort'=> int 11'status'=> int 0