->result() not showing all rows/data

[quote pid='365920' dateline='1562724737']

PHP Code:

                            foreach ($query as $value) {
                    $this->db->where('category_lists_id', $value->category_lists_id);
                    $querys = $this->db->get('category_lists');
                    //print_r($query);
                    return $querys->result();
                } 


[/quote]

I did not read all your question BUT why there is return statement in your foreach loop?

Also you should learn SQL, this is not the right of doing such a query. Learn about JOIN clause in SQL, this is basics and power of RDBMS.
It will take some time to learn, but it is what everybody has to do.