php mysql搜索算法_PHP和MYSQL的算法疑问

慕姐8265434

Code/***无限子级递归循环*@param[type]$data[description]*@paraminteger$pid[description]*@return[type][description]*/functionunlimitedForChild($data,$pid=0){$array=array();foreach($dataas$value){if($value['parent']==$pid){$value['child']=unlimitedForChild($data,$value['id']);$array[]=$value;}}return$array;}$data=array(array('id'=>1,'txt'=>'上山打老虎','parent'=>0),array('id'=>2,'txt'=>'一二三四五','parent'=>0),array('id'=>3,'txt'=>'老虎不在家','parent'=>1),array('id'=>4,'txt'=>'啦啦啦啦啦','parent'=>1),array('id'=>5,'txt'=>'啊啊啊啊啊','parent'=>2),array('id'=>6,'txt'=>'嗯嗯恩恩恩','parent'=>0),//附加3级array('id'=>7,'txt'=>'第三级','parent'=>3),);$result=unlimitedForChild($data);echo'';print_r($result);echo'';ResultArray([0]=>Array([id]=>1[txt]=>上山打老虎[parent]=>0[child]=>Array([0]=>Array([id]=>3[txt]=>老虎不在家[parent]=>1[child]=>Array([0]=>Array([id]=>7[txt]=>第三级[parent]=>3[child]=>Array())))[1]=>Array([id]=>4[txt]=>啦啦啦啦啦[parent]=>1[child]=>Array())))[1]=>Array([id]=>2[txt]=>一二三四五[parent]=>0[child]=>Array([0]=>Array([id]=>5[txt]=>啊啊啊啊啊[parent]=>2[child]=>Array())))[2]=>Array([id]=>6[txt]=>嗯嗯恩恩恩[parent]=>0[child]=>Array()))