s
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_relations tugr ON tugr.user_id = tu.id
LEFT JOIN tbl_users_groups_permissions tugp ON tugp.user_id = tu.id AND tugp.group_id=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'