Nesting queries within active record

[eluser]E.T.Cook[/eluser]
[quote author="Colin Williams" date="1223285266"]

I will have to loop through the queries, and propagate an array manually. Is that correct?

Yeah, and it doesn't have to be messy. That's the way it is done if you are going to optimize your queries by employing JOINs. The other option is to run a query for each other item.[/quote]

The problem I face is this: even if I optimize the queries with a join, I will have to nest some loops to display it correctly...since I would want it to be displayed like this...

Ford
F-150
Focus
Taurus

Audi
A-4
A-6

and not

Ford F-150
Ford Focus
Ford Taurus

So it is 6 in one hand, half a dozen in another.