CI框架 中的三表联查

 

 

$this->_table = 'apps_fans';
$this->db->where('apps_fans.phone IS ', 'NOT NULL', FALSE)->where('apps_fans.phone <>', '');
$this->db->select('apps_fans.*,wechat_fans.nickname,wechat_fans.headimgurl,count(apps_bbs_fans.fan_openid) as count_fans');
$this->db->join('wechat_fans', 'apps_fans.openid = wechat_fans.openid', 'left');
$this->db->join('apps_bbs_fans', 'apps_fans.openid = apps_bbs_fans.star_openid', 'left');
$this->db->group_by('apps_fans.openid');
$this->db->order_by('is_verify', 'asc');

这段代码是查出来的数据是  粉丝  和  明星  的所有信息   以及  明星发展了多少个粉丝