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;