Yii2 get data from two tables at once?

Question

Yii

Hello. I need to get data from 2 tables - users and users_info. I read that in the model (user turns out) you need to create a getter like getUsersinfo where you need to write something like Question: why can't you work with 2 models in the controller and what is the difference between setting hasOne connections and the above method. And which is better to use?
return static::findOne(['user_id'=>$id]);

Answer 1

If you have a relationship, then using this will get records from two tables.

// relation
public function getUserInfo()
{
     return $this->hasOne(User::class, ['id' => 'user_id']);
}
//query
$model = User::find()->with('userInfo')->one();

You can remove data from a connection like this . Here is a lot of useful information for working with connected data.