mysql - Yii2 find-all + hasone

Question

我有 2 个表:

  "article":
|id|name|text|

  "article_permissions"
|article_id|val|

所以，我不想将 article_permissions 加入 Article::find()->all();(并按 article_permissions::val 进行过滤)。

我试过这样做:

Article::find()->with('articlePermissions')->all()

以及 ArticleModel 中的函数(由 gii 生成):

public function getArticlePermissions()
{
    return $this->hasOne(ArticlePermissions::className(), ['article_id' => 'id']);
}

但它返回:

The "query" property must be an instance of a class that implements the QueryInterface e.g. yii\db\Query or its subclasses. :(

我做错了什么？

Answer 1

答案是改变这个:

Article::find()->with('articlePermissions')->all();

为此:Article::find()->with('articlePermissions');