Codeigniter 3 - Query Builder 'join' Method Issue - Records Repeating
Hope this will help you :
You should add group_by in your query to get the desired result
$query = $this->db ->select('category_level_1.id, category_level_1.category') ->from('category_level_1') ->join('category_level_2', 'category_level_2.cat_lvl1_id = category_level_1.id', 'inner') ->group_by('category_level_1.id') ->get(); /*print_r($query->result());*/For more : https://www.codeigniter.com/user_guide/database/query_builder.html