tp5关联统计

例如: category 模型中 关联article模型 

//分类关联文章一对多
public function article() {
    return $this->hasMany('Article', 'categoryid', 'categoryid')->field('id,title_name,status');
}

$rslist = Category::withCount( 'article')->select([1,3,6]);
foreach( $rslist as $row){
    echo '<pre>';print_r($row->article_count);    //默认统计名以“关联方法名+_count”为名
}
/*结果: 5
        3
        2
*/

$rslist = Category::withCount( [ 'article'=>function( $query){
    $query->where('status',0);
}])->select([1,3,6]);
foreach( $rslist as $row){
    echo '<pre>';print_r($row->article_count);
}

//自定义属性名 art_count
$rslist = Category::withCount(['article' => 'art_count'])->select([1, 3, 6]);
foreach( $rslist as $row){
    echo '<pre>';print_r($row-> art_count);
}

本文来自投稿，不代表站三界导航立场，如若转载，请注明出处：https://www.zhansanjie.com/article/details/8380.html