I have two eelated tables:

• login(id, name, role, login_user_id)
• teacher(teacher_id, teacher_branch_id)

I need to filter results to where role is 2.

$this->db->select('*');     
$this->db->from('teacher');     
$this->db->where('teacher_branch_id', $this->session->userdata('branch_id'));
$this->db->join('login', 'teacher.teacher_id = login.login_user_id');
        
$query = $this->db->get();