How to make a hasMany connection by two parameters?

Question

MySQL

there are 2 tables:
user (standard for yii advanced), id + other
user_relations fields in which id (PK), user_id, invite_id, type
you need to make a relationship that will select all user_relations, where either user_id or invite_id is equal to user-> id
try like this:

public function getFriendsList(){
        return $this->hasMany(UserRelation::className(),['user_id'=>'id'])->orWhere(['invite_id'=>$this->id]);
    }

there are no errors, but the sample is empty. I climb into the debug and see that my orWhere has turned into AND:

SELECT * FROM `user_relation` WHERE (`invite_id`=1) AND (`user_id`=1)

Am I sick or yii?
also tried like this:

public function getFriendsList(){
        return $this->hasMany(UserRalation::className(),['user_id'=>'id'])->orOnCondition(['invite_id'=>'id']);
    }

the result is identical

Answer 1

At the moment, in my opinion, the problem is in yii. Run query builder for now

Answer 2

https://github.com/yiisoft/yii2/blob/master/framew...
Попробуйте так:

public function getFriendsList(){
  return $this->hasMany(UserRelation::className(),['user_id'=>'id'])->where(['or', ['user_id' => $this->id],['invite_id'=>$this->id]);
}

А вообще уместнее будет:

public function getFriendsList(){
  return UserRelation::find()->where(['or', ['user_id' => $this->id],['invite_id'=>$this->id]);
}