select t1.fscore,count(0)fcount from tnotice_users t1
inner join tenterprise_users t2 on t1.siteid=t2.siteid and t1.tenterprise_userid=t2.tenterprise_userid and t2.fusertype='¾­ÏúÉÌ'
where t1.siteid=$siteid$ and t1.tnoticeid=$tnoticeid$
group by t1.fscore