Yii2.0框架模型多表关联查询示例

本文实例讲述了yii2.0框架模型多表关联查询。分享给大家供校园安全内容大家参考，具体如下：

联表查询–hasmany：

u app\models\ur;$right = right::findone(2);//$ur = ur::find()->where(['right_id' => $right->attributes['id']])->all();$ur = $right->hasmany(ur::classname(),['right_id' => 'id'])->all();//right_id为ur::classname()表中字段，id为right::findone(2)表字段

多表关联一对多查询优化

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

\models\rught.php

namespace app\models;u \yii\db\activerecord;class right extends activerecord{  public function geturs()  {    $urs = $this->hasmany(ur::classname(),['right_id' => 'id'])->asarray()p->all();    return $urs;  }}

\controller\home\actionabout

public function actionabout(){  $right = right::findone(2);//  $urs = $right->getrights();  $urs = $right->rights;  dd($urs);  return $this->render('about');}

有关自律的作文多表关联一对一查询

\models\ur.php

namespace aplol符文页怎么增加p\models;u \yii\db\activerecord;class ur extends activerecord{建国大业 观后感  public function getright()  {    $right = $this->hason风开头的四字成语e(right::classname,['id' => 'right_id'])->asarray();    return $right;  }}

\controller\home\actionabout

$ur = ur::findone(1);$right = $ur->ur;dd($right);return $this->render('about');

join

//查询关联表的所有数据$ur = ur->find()->with('right')->asarray()->all();