SELECT
    r.name,
    group_concat(group_id separator ',') as group_ids
FROM tbl_users_groups_permissions
INNER JOIN roles r on tbl_users_groups_permissions.role_id = r.id
WHERE user_id = 1377
GROUP BY r.name

SELECT
    r.name,
    CONCAT('[', GROUP_CONCAT(group_id separator ','), ']') as group_ids
FROM tbl_users_groups_permissions
INNER JOIN roles r on tbl_users_groups_permissions.role_id = r.id
WHERE user_id = 1377
GROUP BY r.name

ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (111 "Connection refused")