Joining two tables

I have 2 tables that i want to join & show the name of user's role. here's the situation

My 2 tables are users_mlh & user_roles_mlh

on the role column of users_mlh table i'm storing the ID of user role, user_roles_mlh contains the name  & id of user role. what i want to do is show the name of the user role in my view.

my tables as follows.


i have tried this in my model 

PHP Code:

$this->db->select('*');
$this->db->from('user_roles_mlh');
$this->db->join('users_mlh', 'users_mlh.role = user_roles_mlh.id');
$this->db->where('users_mlh.role = user_roles_mlh.id');
 
$query = $this->db->get();

return $query->result_array(); 


   
 but from above i get something like this



at the moment it lists all user level not the role of each individual user