How to exclude records from ActiveRecord whose id is obtained in another ActiveRecord?

Question

Yii

There is a table of users Users
There is a table of user groups Groups
There is a table for linking users and groups group_users
There is a getUsers() method in the Groups model

public function getUsers()
    {
        return $this->hasMany(Users::className(), ['id' => 'user_id'])->via('groupUsers');
    }

This method works perfectly and correctly.
There is a Team model, and a table for the team_users connection
And exactly the same method

public function getUsers()
    {
        return $this->hasMany(Users::className(), ['id' => 'user_id'])->via('teamUsers');
    }

You need to get a list of all users from the group not included in the team. I know how to do it via innerJoin and how to do it via array_diff_key().
How to do it through ActiveRecord?

Answer 1

Goodnight. You can also use Join
in ActiveRecord