如何使用数组Laravel 5返回一个json

Question

I do have a table with data like this

Product

id     |    name   |     day    |    time
1      |    prod1  |     MON    |    08:30
2      |    prod1  |     MON    |    09:30
3      |    prod1  |     TUE    |    10:30
4      |    prod2  |     WED    |    05:30
5      |    prod3  |     MON    |    11:30

how do I return it in POSTMAN like this:

prod1 {
     "MON" : [
          08:30,
          09:30
      ],
     "TUE" : [
          10:30
      ]
}

Answer 1

try this one:

$products = Product::all();
$jsonOutput = [];

foreach($products as $product){
   $jsonOutput[$product['day']][] = $product['time'];
}

return response()->json($jsonOutput);