$sql?=?'select?*?from?goods_type?where?parent_id?=?$pid';

$result?=?mysqli_query($mysqli,$sql);
//定義一個(gè)函數(shù)
function?infinite($pid?=?0,&$data?=?array(),$spac=0){
????//include?"db.php";
????/*
?????*
?????*?查出pid為0的子類
?????*?**/
????$spac+=2;
????global?$result;

????//var_dump(?$result);die;
????//定義一個(gè)數(shù)組接收數(shù)據(jù)
????//$data?=?array();
????while($row?=?mysqli_fetch_array($result))
????{

????????$row['type_name']=str_replace(' ',$spac).'|--'.$row['type_name'];
????????//將查詢的值給$data
???????$data[]?=$row;

????????//遞歸查詢
????????infinite($data['id'],$data);
????}
????return?$data;
}