Hello Everybody, i new here and really need some help,

i have this code which it shows me all the users i have but i created a new module to only show me users from a specific role (ei: admin, supervisor, etc) tthe roles are in another table in my mysql how can i show only user from specific role:

tableName1 is my users and tableName2 is my roles

// SETUP PAGING VARIABLE
// ------------------------------------------------------------
$tableName1="users";
$tableName2="users_in_roles";
$targetpage = "resellers.php";
$limit = GV_PAGE_SIZE;
$stages = 2;

// ------------------------------------------------------------
// GET DISPLAY QUERY STRING VALUE
// ------------------------------------------------------------
if(isset($_GET['display']) && !empty($_GET['display']) && is_numeric($_GET['display']) && $_GET['display'] >= 0 && $_GET['display'] <= 1000)
{
$display = strip_tags($_GET['display']);
$_SESSION['display'] = $display;
$limit = $_SESSION['display'];
$remember_limit = $limit;
}
else
{
$display = $limit;
}

/