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;