Is there a way to group (groupBy) users by registration dates?

Question

Laravel

An example of grouping by user status in Laravel. And how to group users by registration date - for example, January February March, etc.?

$users = DB::table('users')
                     ->select(DB::raw('count(*) as user_count, status'))
                     ->where('status', '<>', 1)
                     ->groupBy('status')
                     ->get();

Answer 1

Try like this -

$users = DB::table('users')
                     ->select(DB::raw('count(*) as user_count, status'))
                     ->where('status', '<>', 1)
                     ->groupBy(function($user) {
                           return Carbon::parse($user->created_at)->format('m');
                       })->get();

Answer 2

in select select DATE_FORMAT(t.reg_dt, '%Y%m') AS reg_ym
in groupBy - by reg_ym and group.