Laravel Query Group, Year, Month, Day

.php

       $usage = DB::table('styles')
                   ->select(
                        DB::raw('count(id) as `total_created`'),
                        DB::raw("DATE_FORMAT(created_at, '%d-%m-%Y') new_date"),
                        DB::raw('
                            YEAR(created_at) year,
                            MONTH(created_at) month,
                            DAY(created_at) day')
                        )
                    ->groupby('year','month','day')
                    ->get();