How to get data from 2 related tables in the same controller?

PHP Code:

$this->db->select('d.*, o.*')
->from('departments d')
->join('occupations o', 'o.department_id = d.department_id', 'LEFT') 


Simple join it is all you have to do, and you should learn JOIN clause in SQL.