SELECT
a.id AS article_id,
u.uid,
u.shareplat,
u.collection,
u.readtime,
a.artidlink,
a.title,
a.arturl,
a.readcount
FROM
user_article_link AS u,
article AS a
WHERE
u.artid = a.id
AND u.uid = 1
AND u.shareplat=1上面是原生SQL语句如何以模型的方式实现呢?
目前我实现到
class Article extends Model{
public function userArticleLink()
{
return $this->hasOne('UserArticleLink','artid', 'id')->bind('uid,shareplat,collection');
}
}$artical = new Article;
$rs = $artical->hasWhere('userArticleLink',['uid'=>'1','status'=>'1'])->select();这样得到的输出不包含上文bind的属性$rs = $artical->with('userArticleLink')->where("?")->select();这样写where条件无法使用关联表的uid请问这该怎么办呢?
最佳答案
