get role

select au.value as username, au.description as user, ar.name as role from ad_role ar
left join AD_User_Roles aur on ar.ad_role_id = aur.ad_role_id
left join ad_user au on aur.ad_user_id = au.ad_user_id
where ar.name in (
'AOI User Payment Kasir',
'AOI User AP',
'AOI User AP 2',
'AOI User Accessories Receipt',
'AOI PPC Subcont User')