How to make connection in yii2 many-to-many with negative condition?

Question

Yii

There are three tables: firms, categories and a table with the category belonging to the firm: firm_category.
To get all categories of our company, I use the following many-to-many relationship:

public function getCategories()
    {
        return $this->hasMany(Category::className(), ['id' => 'category_id'])
            ->viaTable('company_category', ['company_id' => 'id']);
    }

Is it possible to build such a many-to-many relationship where you get non -company categories?
What is the correct way to implement such a task?

Answer 1

try inserting !

Answer 2

1. Get what belongs to your firm.
2. Get all categories.
3. Subtract from from the total osprey belonging to.
4. The rest show where you need.
5. Wrap all requests in a transaction. And pre-index the fields by which you select. The base will thank you =)
Perhaps there is a more capacious solution, but this is from the category of the obvious.

Answer 3

Anton Natarov , I usually used this option.
I thought maybe you can do it somehow "beautifully" by means of links specified in the framework. So I decided to ask here.