php - laravel如何获取本月注册用户数

Question

请帮助我获取本周注册的用户数和本月注册的用户数

标签： phplaraveleloquentlaravel-6laravel-datatables

Answer 1

你可以试试这个：

$lastWeekUsersCount = \App\Models\User::whereDate('created_at', '>=', \Carbon\Carbon::now()->addWeeks(-1))->count();
$lastMonthUsersCount = \App\Models\User::whereDate('created_at', '>=', \Carbon\Carbon::now()->addMonths(-1))->count();