user_model.php

<?php

public function find_all_by_role($role)
{
	return $this
		->join('roles_users', 'users.id', 'roles_users.user_id')
		->join('roles', 'roles_users.role_id', 'roles.id')
		->where('roles.name', $role)
		->find_all();
}