How to make connection with OR?

Question

Yii

I drove myself with such a base:
id | article_id | product_id |company_id
In the Forum model, I make a connection with this model to select everything where product_id = product_id or company_id = company_id
So far I have this:

public function getRelatedArticles(){
        return $this->hasMany(ArticleRelation::className(),['product_id'=>'product_id'])->union($this->hasMany(ArticleRelation::className(),['company_id'=>'company_id']));
    }

It works, but the thought that this is hellish idiocy does not leave me. I think to get away from communication in general and just make a selection. But communication is more convenient. Any ideas?

Answer 1

$this->hasMany returns ActiveQueryInterface , you can try to use some one instead of hasMany

$query = ArticleRelation::find()->where(/*ваши фильтры*/);
$query->multiple = true;
return $query;

Haven't tried it myself, but it might work.