Query from view

[eluser]Colin Williams[/eluser]
1. Use a JOIN query to get all the data you need.
2. In the model after the query, iterate over the result, grouping multiple values. You should end up with a multidimensional array of posts, where each post has a user property that is an object containing the user data
3. Pass this on to the view

This is a basic workflow. If you don't know how joins work, or how to manipulate arrays, I would suggest you go back to square one and do some reading on each of those topics.