left join

select e.en_id,e.en_name,ifnull(u.qq,0) as qq from wx_enterprise e left join (select count(*) as qq,enterprise_id from wx_user group by enterprise_id) u
on e.en_id = u.enterprise_id