select tenterprise_userid,t1.fname,t1.tstoreid,t2.fstorename,t1.frole,t1.fshortcode,
t1.fphonenumber,0 as logintimes from tenterprise_users t1
left join tstore t2 on t1.siteid=t2.siteid and t1.tagentsid=t2.tagentsid and t1.tstoreid=t2.tstoreid
where t1.siteid=$siteid$ and t1.tagentsid=$tagentsid$ and t1.fusertype='¾­ÏúÉÌ'
