DataMapper ORM v1.8.0

[eluser]WanWizard[/eluser]
Something like this:

Code:

class User extends Datamapper
{

    // ... your config here

    public method get_all_posts()
    {
        // run the query
        $this->include_related('post', 'post')->include_related('post/comment', 'comment')->get();

        // always return the current object so you can chain
        return $this;
    }

}

Then in your controller you can use

Code:

$u = new User();

$u->get_all_posts();

include_related() runs a JOIN, so in an 1:n relation the parent will be repeated, that is the nature of the join. Datamapper doesn't distribute the result back to related objects (that's funcctionality on the roadmap for 2.0).