TP6模型多对多关联查询

User模型

class User extends Model 
{
    public function roles()
    {
        return $this->belongsToMany(Role::class, Access::class);
    }
}

多对多关联查询

// User表查询条件
$map=[];
// Role表查询条件
$where=[];
$data = User::with(['roles'=>function($query) use($where){
	$query->getQuery()->where($where)->limit(10);
}])->where($map)->select();

或

// User表查询条件
$map=[];
// Role表查询条件
$where=[];
$user = User::where($map)->find(1);
$roles = $user->roles()->where($where)->limit(10)->select();

210906补充：同时满足User表和Role表查询条件

// User表查询条件
$map=[];
// Role表查询条件
$where=[];
$uids= Role::where($where)->column('uid');
$map[] = ['uid','IN',$uids];
$user = User::where($map)->select();