Tp6 五表联查

user模型:

protected $table='login';
protected $pk='id';

public function getrole(){
    return $this->belongsToMany(role::class,'u_r','role_id','id');
}

public function show($name){
    return $this->where('name',$name)->with('getrole.get')->find();
}

角色role模型:

protected $table='role';
protected $pk='role_id';

public function get(){
    return $this->belongsToMany(power::class,'power_role','power_id','role_id');
}

用户角色表u_r:

权限power模型:

protected $table='power';

protected $pk='power_id';

角色全选表power_role 模型:

protected $table='power_role';
protected $pk='power_id';

用户user控制器:

public function dologin(Request $request){
    $name =$request->param('name');
    $pwd =$request->param('pwd');
    $data =new loginmodel();
    $res =$data->dologin($name,$pwd);
    if ($res==1){
        $token =JWTAuth::builder(['name'=>$name,'pwd'=>$pwd]);
        return success(200,'登录成功',$data=['token'=>$token]);
    }elseif ($res ==2 ){
        return success(300,'密码错误',$data=['pwd'=>$pwd]);
    }elseif ($res == 3){
        return success(500,'账号不存在',$data=['name'=>$name]);
    }
}

public function token($id=1,$name=123){
    $token =JWTAuth::builder(['uid'=>$id,'name'=>$name]);
    return $token;
}
//联查
public function show(Request $request){
    $name = $request->param('name');
    $data =new \app\admin\model\login();
   $obj = $data->show($name)->toArray();

    return dd($obj);
}