Laravel fetch array of arrays with groupBy

Question

I have a Laravel table posts with multiple categories. How can I fetch all the posts grouped by categories? I was doing something like Post::where('userID', 1)->groupBy('categoryID'). But this only returned a flat array of named arrays like this:

[1 => ['title'=>'title 1'], 2 => ['title'=>'title3']]

How can I return an array of arrays like this:

[1 => [['title'=>'title 1'], ['title' => 'title 2], 2 => [['title'=>'title 3']]]

UPDATE: I'm currently doing a join and then use Laravel's collection to sort it in php:

   Post::join('categories', ....).where('userID', 1)->get()->groupBy('categoryID');

I am able to get what I want, but wondering if there is a better way?

The Alpha · Accepted Answer · 2014-06-17 02:39:28Z

1

You may want this:

$catsWithPosts = Category::with(array('posts' => function($query){
    $query->select('title')->where('userID', 1);
}))->get();

Assumed that, you have declared proper relationship between Post and Category model.

edited Jun 17, 2014 at 2:39

answered Jun 17, 2014 at 0:36

The Alpha

147k30 gold badges294 silver badges313 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

randomor Over a year ago

Thanks, but the userID is on posts. This seems to be not working.

The Alpha Over a year ago

Which table contains category_id ?

randomor Over a year ago

This seems to work. But looking at the documentation, I'm wondering if I'm doing n queries depending on my categories count? laravel.com/docs/eloquent

The Alpha Over a year ago

No, it's not n+ queries because it's using eager loading technique.

Collectives™ on Stack Overflow

Laravel fetch array of arrays with groupBy

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related