Yii 利用query联表查询

Yii2.0联表查询

$query = (new \yii\db\Query())            ->select('a.id as aid,title,author,addtime,c.name')            ->from('article AS a')            ->leftJoin('category AS c','c.id = a.cid')            ->limit(4)            ->where('a.is_delete=0')            ->orderBy('a.id DESC')            ->All();           var_dump( $query);die;