我的原始语句是：
$query = ArticlesSearhch::find()->where(['isDeleted'=>0])->joinWith(['authors']);
因为article中的content字段内容很多，所以我现在不想全查出来，只查出title、authorId、lastEdited等几个字段，这个select()语句该怎么写？
ArticlesSearhch中的authors
public function getAuthors()
{
return $this->hasOne(TbAuthors::className(), ['id' => 'authorId'])
->asArray();
}
我改写成下面这样，报错：
$query = ArticlesSearhch::find()->select('articles.id','articles.title','articles.authorId','articles.lastEdited','articles.format')->where(['articles.isDeleted'=>0])->from(['articles'=>'articles'])->joinWith(['authors']);
报错信息：
Database Exception – yii\db\Exception
SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'COUNT(*) FROM `articles` `articles` LEFT JOIN `authors` ON `articles`.`authorId`' at line 1
The SQL being executed was: SELECT articles.title COUNT(*) FROM `articles` `articles` LEFT JOIN `authors` ON `articles`.`authorId` = `authors`.`id` WHERE `articles`.`isDeleted`=0
求大神帮忙！谢谢！
搞定，格式写错了，改成这样就可以了:
$query = ArticlesSearhch::find()->select(['articles.id','articles.title','articles.authorId','articles.lastEdited','articles.format'])->where(['articles.isDeleted'=>0])->from(['articles'=>'articles'])->joinWith(['authors']);
self::find()
这样试试
