根据当前id查询一级id 后代查祖先

function inquireID($list,$cate_id,$filed="*"){
    static $arr= [];//静态变量
$sql = "select $filed from $list where id=$cate_id";
$row = getOne($sql);
if ($row && $row['pid']>0){
    $arr[]=$row['id'];
    //递归查询
    inquireID($list,$row['pid']);
}else{
//    var_dump($row);
//    echo $row['cate_name'];
    $arr[]=$row['id'];
}
return $arr;
}

 

posted @ 2022-03-18 15:37  早早早点睡觉  阅读(82)  评论(0)    收藏  举报