## 遞歸查詢 其中 pid是id的父級別 相互對應 ### 例子1 ~~~ public function getcatebypid($pid) { $data = Db::table("cates")->where("pid", $pid)->select(); $res = []; //遍歷 遞歸 foreach ($data as $key => $value) { // 代碼段：核心點 $value['shop'] = $this->getcatebypid($value['id']); $res[] = $value; } return $res; } ~~~ ### 例子2 ~~~ function getList($brr, $pid = 0, &$arr = [], $level = 1) { foreach ($brr as $v) { if ($v['pid'] == $pid) { $v['level'] = $level; $arr[] = $v; getList($brr, $v['id'], $arr, $level + 1); } } return $arr; } ~~~ ### 例子3 將列表轉化為樹狀 ~~~ static function listToTree($list,$root_id = 0){ $arr = []; foreach($list as $item){ if ($item->pid == $root_id) { $children = self::listToTree($list, $item->id); if($children){ $item->children = $children; } $arr[] = $item; } } return $arr; } ~~~ 調用1 其中0是pid 表示獲取0下所有的子級別數據 `getcatebypid(0)` 調用2 ~~~ getList(db("user)->select(),$user['role_id']); {:str_repeat('|——',$vo.level)}{$vo.name} //tp5模板用法 ~~~