yii2.0--模型多表关联查询

 联表查询--hasMany：

use app\models\User;

$right = Right::findOne(2);
//$user = User::find()->where(['right_id' => $right->attributes['id']])->all();

$user = $right->hasMany(User::className(),['right_id' => 'id'])->all();
//right_id为User::className()表中字段，id为Right::findOne(2)表字段

多表关联一对多查询优化

如果多次用到同表相同查询：

\models\Right.php

namespace app\models;

use \yii\db\ActiveRecord;

class Right extends ActiveRecord
{
    public function getUsers() 
    {
        $users = $this->hasMany(User::className(),['right_id' => 'id'])->asArray()->all();
        return $users;
    }
}

\controller\home\actionAbout

public function actionAbout()
{
    $right = Right::findOne(2);
    $use