PHP查找数据库中自己的所有子集,包括子集的子集,
public function getDataFind($table,$where=[]){
$data = Db::name($table)->where($where)->field('id,pid,username')->find();
return $data;
}
public function getParent($uid){//当前用户id
static $arr = [];
$member = DB::name('user')->where('pid',$uid)->field('id,pid,username')->select();
foreach ($member as $member){
if ($member['id'] > 0){
$parent = $this->getDataFind('user',array('id'=>$member['id']));
$arr[]=$parent['id'];
$this->getParent($parent['id']);
}
}
return $arr;
}
结果