## **1.遞歸查詢** ~~~ static public function infinityCategory($data,$fid=0) { $ruleArr = []; foreach ($data as $k => $v) { if ($v['fid'] == $fid) { $v['lower'] = self::infinityCategory($data,$v['id']); $ruleArr[] = $v; unset($data[$k]); } } return $ruleArr; } ~~~ ## **2.查詢所有分類并在子分類加|----** ~~~ static public function getCates(){ //獲取數據并排序 $cates_data = Db::query("select *,concat(path,',',id) as paths from shop_cates order by paths"); foreach ($cates_data as $key => $value) { //統計$value->path中 ,出現的次數 $n = substr_count($value['path'],','); //重復使用一個字符串 $cates_data[$key]['name'] = "".str_repeat('|----',$n).$value['name']; } return $cates_data; } ~~~