How to refine a query in Yii?

Question

MySQL

I have 2 tables:
USER
id, name, surname
UserUser
u_id1, u_id2, date, status
I have this action in the USER model:

public function getUsers($status)
    {
        return $this->hasMany(UserUser::className(), ['u_id1' => 'id'])
            ->where(['status' => $status]);
    }

But I also need to add the ability to search for name, surname from the User table, if I add WHERE or Like, it
writes an error that such columns (name, surname) were not found in the UserUser table?
How do I add these 2 values ​​to the search or return value?
I am using Yii2.

Answer 1

return $this->hasMany(User::className(), ['id' => 'u_id2'])->viaTable(UserUser::tableName(), ['u_id1' => 'id'],
function($ query) {
$query->where(['status' => 1]);
})->andWhere(['like', 'name', $input])
->orWhere(['like', 'surname' , $input]);

Answer 2

Try like this:

public function getUsers($status)
    {
        return $this->hasMany(static::className(), ['id' => 'id'])
            ->viaTable('{{%UserUser}}', ['u_id2' => 'id'])
            ->where(['status' => $status]);
    }

Official Guide Info:
https://github.com/yiisoft/yii2/blob/master/docs/g...