light-apiengine/models/Sql_SysUser.go

package models

var SqlUserLogin = ` 
        select 
			id,login_id,password,name,full_name,email,org_id,type,status,domain,create_by,create_time,last_update_by,last_update_date,del_flag
        from sys_user
		where login_id = ?`

var SqlUserInfoPage = `SELECT 
  sys_user.*,
  sys_org.name org_name,
  GROUP_CONCAT(sys_role.name) role_name
FROM
  sys_user 
LEFT JOIN
  sys_org
  ON
  sys_user.org_id=sys_org.id
  LEFT JOIN
  sys_user_role
  ON
  sys_user_role.user_id = sys_user.id
  LEFT JOIN
  sys_role
  ON
  sys_role.id = sys_user_role.role_id
  WHERE
  sys_user.del_flag = 1
  GROUP BY
  sys_user.id`