CI do not have model to model relationships as like Yii. Plz implement if possible.

CI do not have model to model relationships as like Yii. Plz implement if possible.

example u have table_one and want to join table_two using their id

Code:

$this->db->select('columns');
$this->db->from('table_one');
$this->db->join('table_two', 'table_two.id = table_one.id');

I know with yii, you can do it this way:

Code:

$posts=Post::model()->with(
'author.profile',
'author.posts',
'categories')->findAll();

this feature should be integrated in CI4. The benefit for implementing this is user ended up with optimized query.