SQL中以另外一张表的字段去统计本表的分组

select name,value , if(aa.id != '',count(aa.name),0) from ( SELECT d.label AS name ,d.value ,p.id as idselect name,value , if(aa.id != '',count(aa.name),