数据库为postgresql,sql如下:
SELECT
"domain"."user"."id",
"domain"."user"."email",
"domain"."user"."real_name",
"domain"."user"."mobile",
"domain"."user"."we_chat",
"domain"."user"."created_at",
string_agg ( "domain"."role"."name", ',' ) as "role_names", #将name字段聚合拼接成以逗号分隔的字符串
"domain"."account"."remark"
FROM
"service"."organization_user"
LEFT OUTER JOIN "domain"."user" ON "service"."organization_user"."user_id" = "domain"."user"."id"
LEFT OUTER JOIN "domain"."account" ON "domain"."user"."id" = "