Hello --

I would like to add a function to my model:

(assume a blog where users have posts, and posts have comments)

class Posts extends Eloquent { protected $table = 'posts';

public function comment_count() {
    return $this->hasCount('comments', 'post_id', 'post_id');
}

}

and then query a user with all of its posts, and a comment count on each of their posts- using something along the lines of:

User::with(array("posts", "posts.comment_count"))->get();

I could easily make it users with all posts, and posts with all comments, but if there are a lot of comments and I don't need the data, I would rather just get the count.

Any thoughts or direction to go?

Thanks, Todd