SubQuery

How do this:

$query = $this->db->table('catalog as C')->select(*)
->select('(SELECT `title` FROM `help_catalogs` WHERE `id` = c.parent) AS SubCatalogTitle')

This is how you can handle subqueries: https://www.codeigniter.com/user_guide/d...subqueries

This is how you can handle subqueries: https://www.codeigniter.com/user_guide/d...subqueries

I have variable in subquery which in main query