Laravel eloquent returning array array

To group your data by day and month and count, you need to work with groupBy eloquent to group and count the rows all in commands that will bring the result without the expected layout, then use the transform method to format the output with the following example > :

$data= \App\Logs::select(\DB::raw('count(id),date(created_at)'))               
    ->groupBy('date(created_at)')
    ->get()
    ->transform(function($item, $key)
    {
      return [\Carbon\Carbon::parse($item['date(created_at)'])
          ->format('d-M-') => $item['count']];
    });

• Collections
• Ccollections - transform
• Carbon
• Database: Query Builder - Ordering, Grouping, Limit, & Offset

Guilherme, I know your question was specific about the query in eloquent . But without the bank's structure it is difficult to help you. A palliative solution would be to use array_map in the result to format the output of the query information.

Something like this:

$array = [
    '06-Jul-' => [

            [
                "id" => 1,
                "created_at" => "2017-07-06 13:21:15"
            ]
        ],
    '07-Jul-' => [
            [
                "id" => 2,
                "created_at" => "2017-07-07 13:43:23"
            ],
            [
                "id" => 3,
                "created_at" => "2017-07-07 14:18:36"
            ],
            [
                "id" => 4,
                "created_at" => "2017-07-07 14:18:41"
            ]
        ]
];

$array = array_map(function($item){
    return count($item);
}, $array);

var_dump($array);

Result

array(2) {
  ["06-Jul-"]=> int(1)
  ["07-Jul-"]=> int(3)
}