查询上三级，下三级

    public function getSearchDealer($type='',$name='',$mobile='')
    {
        //分销商
        $dealer = new UserModel; 
        $name = input('get.real_name');
        if(!empty($name))
        {
            $where[] = ['real_name','=',$name];
        }
        
        $mobile = input('get.mobile');
        if(!empty($mobile))
        {
            $where[] = ['mobile','=',$mobile];
        }
        $where[] = ['is_delete','=',0];
       
        $list = $dealer->where($where)->field('real_name as partner_name,user_id')->find();//查出自己
        $user_id = $dealer->where($where)->value('user_id'); 
        $list["children"] = $this->getTree($user_id);//查出下级
        
        if($type==1){
            $list["superior"] = $this->getSuperior($user_id); //上级
        }
       
        return $this->renderSuccess(compact('list'));
    }
    public function getSuperior($user_id,$i=1){
        //推荐人
        $list = RefereeModel::where(["user_id"=>$user_id,"level"=>1])->find();
        $tree = [];
        if(!empty($list)){
            $i++;
            if($i>3){
                return ;
            }
            $tree[]= UserInfoModel::where("user_id",$list['dealer_id'])->field('nick_name')->find();
            $tree[0]['superior'] =$this->getSuperior($list['dealer_id'],$i);
        }
        return $tree; 
    }
    public  function getTree($user_id,$i=0)
    {   
        //推荐人
        $list = RefereeModel::where(["dealer_id"=>["=",$user_id],"level"=>1])->where('dealer_id','>','0')->select()->toArray();
       
        $tree = [];
        if(!empty($list)){
            $i++;
             if($i>3){
                return ;
            }
            foreach ($list as $key => $val) { 
                $tree[$key]= UserInfoModel::where("user_id",$val['user_id'])->field('nick_name')->find();
                $tree[$key]['children'] = $this->getTree($val['user_id'],$i);
            }
        }
        return $tree;
    }