TP查询当前用户是否关注当前文章并且查看当前文章的关注数量

public static function read($param){
        $map['d.id'] = $param['id'];
        
        $subsql = model('ArticleCollection') -> where(['user_id'=>$param['user_id']]) -> buildSql();

        $join = [
            [[$subsql => 'dc'],'d.id=dc.article_id','left']
        ];

        return self::alias('d')->with('copyrights,comments,details')-> withCount(['collection','comments'],false) -> field('d.*,designer_id as designer_info,dc.id as is_coll')->where($map) ->join($join) -> find() ;
    }

public function collection(){
        return $this -> hasMany('ArticleCollection','article_id','id');
    }

 

模型层