PHP 查找自己的所有子集

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;
    }

 结果