How to filter data by related table?

Question

Yii

Hello.
There are User and Company models.

class User extands ActiveRecord{
//
public function getCompany()
    {
        return $this->hasOne(Company::className(), ['user_id' => 'id']);
    }

    public function getIsCompany()
    {
        return $this->company ? true : false;
    }
}

I want to get a list of users who don't have a Company, i.e. something like this

$query = User::find();

$dataProvider = new ActiveDataProvider([
   'query' => $query,
]);
    
$query->where(['company' => false]);

And I get the error that

Unknown column 'company'.

How to do it right?

Answer 1

$dataProvider = new ActiveDataProvider([
   'query' => $query,
]);
    
$query->joinWith('company')->where(['is','user_id',null]);