SELECT a.id,a.onlywx,a.badminwx_id,a.bz,a.toid,a.ctime,b.xm,b.id,b.sj FROM demo_buserwx as a left join (
SELECT `id`,`xm`,`sj` FROM demo_vipuser where (1=1 and `qyid`='3') ) b on b.id = a.toid where (1=1 and a.lx='1')
系统admin2s admin1 二级管理员 管理员 一级管理员1 超级管理员