查询服务拥有的IP和用户密码并分割
SELECT
a.SERVICE_ID,
a.SERVICE_NAME,
(
SELECT
GROUP_CONCAT(b.IP_ADDRESS)
FROM
t_sys_service_ip b
WHERE
a.SERVICE_ID = b.SERVICE_ID
),
(
SELECT
GROUP_CONCAT(c.USER_NAME,',', c.`PASSWORD` SEPARATOR '|')
FROM
t_sys_service_user c
WHERE
a.SERVICE_ID = c.SERVICE_ID
)
FROM
t_sys_service a;