正确的应该是这样子的吧？where条件写错了
SELECT sc_sucai.*,`id_count`,sc_users.id as user_id,sc_users.user_nicename,sc_users.avatar
FROM `sc_sucai`
left join (select count(*) as id_count,sc_id,type from sc_sucai_deal group by sc_id,type ) as b
on sc_sucai.id=b.sc_id
INNER JOIN sc_users ON sc_users.id = sc_sucai.father_id
内容全部来源于网络收集，如有侵权，请联系网站删除：QQ：24596024