Add subquery to main query result instead of running lots of foreachs

[eluser]JoostV[/eluser]
You have every right to be worried about performance

I reckon a join query here would solve the problem.

Code:

$this->db->from('discs');
$this->db->join('songs', 'discs.id = songs.disc_id', 'left');
$this->db->join('versions', 'songs.id = versions.song_id', 'left');
$this->db->where(discs.id, 1);
$versions = $this->db->get();