SELECT tu.id,
       tu.firstname,
       tu.lastname,
       tu.region,
       IF(r.name IS NOT NULL, r.name, 'user') as role_name,
       if(r.name IS NOT NULL, UPPER(LEFT(r.name, 1)), 'U') as role
FROM tbl_user tu
         LEFT JOIN tbl_users_groups_permissions tugp ON tugp.user_id = tu.id
         LEFT JOIN tbl_users_groups_relations tugr ON tugr.user_id = tu.id
         LEFT JOIN roles r ON tugp.role_id = r.id
WHERE tu.id = ?
  AND tugr.group_id = ?
  AND tu.is_delete = '0'
  AND tu.is_active= '1'

user_id, group_id, role_id
1377,3,1
1261,9,1
1337,13,1
1337,1,1

1337,Roman,Mizin,western,admin,A
1337,Roman,Mmizin,western,admin,A

FROM tbl_user tu
         LEFT JOIN tbl_users_groups_permissions tugp ON tugp.user_id = tu.id
         LEFT JOIN tbl_users_groups_relations tugr ON tugr.user_id = tu.id   AND tugr.group_id = ?
         LEFT JOIN roles r ON tugp.role_id = r.id
WHERE tu.id = ?
  AND tu.is_delete = '0'
  AND tu.is_active= '1'

SELECT tu.id,
       tu.firstname,
       tu.lastname,
       tu.region,
       IF(r.name IS NOT NULL, r.name, 'user') as role_name,
       if(r.name IS NOT NULL, UPPER(LEFT(r.name, 1)), 'U') as role,
       tugp.group_id as group_perm,
       tugr.group_id as group_rel
FROM tbl_user tu
    LEFT JOIN tbl_users_groups_permissions tugp ON tugp.user_id = tu.id AND tugp.group_id = ?
    LEFT JOIN tbl_users_groups_relations tugr ON tugr.user_id = tu.id AND tugr.group_id = ?
    LEFT JOIN roles r ON tugp.role_id = r.id
WHERE tu.id = ?
  AND tugr.group_id = ?
  AND tu.is_delete = '0'
  AND tu.is_active= '1'