SELECT ra.id ,CONCAT(u.firstname,' ',u.lastname) AS nama, u.email,r.shortname AS role, c.fullname AS namakursus,c.id AS courseid FROM mdl_user u INNER JOIN mdl_role_assignments ra ON ra.userid = u.id INNER JOIN mdl_context ct ON ct.id = ra.contextid INNER JOIN mdl_course c ON c.id = ct.instanceid INNER JOIN mdl_role r ON r.id = ra.roleid WHERE (r.id=3 OR r.id=4)