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

[eluser]gr0uch0mars[/eluser]
Thanks, I had thought about a JOIN, but this would return only "Versions".
I'd like to present something like:

Disc
- Song 1
· Version 1
· Version 2
· Version 3
- Song 2
· Version 1
- Song 3
· Version 1
· Version 2

I don't know how to group Versions (fetched through your JOIN) into Songs.