Laravel query builder group into nested arrays

Question

I am using Laravel with query builder in my project.

I have the following table:

Table: worker_tasks
+--------+-----------+------------+---------------------+
| id     | worker_id | task_id    | started_at          |
+--------+-----------+------------+---------------------+
| 227350 |     50765 |       2399 | 2021-12-02 12:24:38 |
| 227351 |     50765 |       1377 | 2021-12-12 09:34:22 |
| 227352 |     84245 |       2294 | 2021-12-07 10:37:11 |
+--------+-----------+------------+---------------------+

And I wish to retrieve data into an array of nested arrays, with worker_id as key of each one.
In this case, expected result will be:

[
    50765 => [
        {
          "task_id": 2399,
          "started_at": "2021-12-02 12:24:38",
        },
        {
          "task_id": 1377,
          "started_at": "2021-12-12 09:34:22",
        },
    ],
    84245 => [
        {
          "task_id": 2294,
          "started_at": "2021-12-07 10:37:11",
        },
    ],
]

I tried to use the keyBy collection method, but it takes only one element for each key, as written in documentation:

If multiple items have the same key, only the last one will appear in the new collection

I wonder whether there is a straight way to do it (using some built-in Laravel method).

naamhierzo · Accepted Answer · 2022-03-14 12:21:20Z

2

Use the GroupBy method instead of keyBy

answered Mar 14, 2022 at 12:21

naamhierzo

5403 silver badges12 bronze badges

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

1 Comment

guyaloni Over a year ago

Just to make it clear, the call to groupBy() must be done after the get() call: $query->get()->groupBy(['worker_id']).

Collectives™ on Stack Overflow

Laravel query builder group into nested arrays

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related