select t1.tenterprise_userid, t2.fname, t2.fphonenumber,max(t1.submitdate)as submitdate,count(0)as submitcount
from tsubmitedit 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.tsubmiteditmodelid = $tsubmiteditmodelid$
  and t1.fstatus='Ìá½»'
  group by t1.tenterprise_userid, t2.fname, t2.fphonenumber