Lost in the middle of mysql and objects

[eluser]jedd[/eluser]
[quote author="andriu" date="1256502658"]
I'm not that used with working with objects.
[/quote]

Use arrays, then. The functions are similar. You're under no obligation to use objects to retrieve/access your data.

Can you better describe your three tables. Your indenting, and the code you presented, hints at a hierarchical relationship (which might mean you've misunderstood RDBMS theory), and I'm tempted to suggest two LEFT JOINS against your proforma selection would get you where you want to go ... but your requirements are a tad fuzzy.