查询SQL.sql 213 B

1234
  1. select u.id,u.userName,u.userMobile,u.organizationId,o.name,wu.openId from tb_user u
  2. left join tb_wxuser wu on wu.userId=u.id
  3. left join tb_organization o on o.id=u.organizationId
  4. where u.organizationId in (10,626)