select t1.siteid,t1.tagentsid,t1.tstoreid,t2.fstorename,t1.tenterprise_userid,t1.fname,
t1.fphonenumber,t1.fisadministrator,t1.frole,t1.fsex,t1.fbirthdate,t1.femail,t1.fwechatno,t1.faccountno from tenterprise_users t1
left join tstore t2 on t1.tstoreid=t2.tstoreid
where t1.fusertype='¾­ÏúÉÌ' and t1.siteid=$siteid$ and t1.tagentsid=$tagentsid$