How to count the most active users who wrote posts for the current week?

Question

Laravel

Good afternoon. The situation is something like this. There is a posts table, in this table, among other things, there are user_id and post. It is necessary to somehow calculate the 3 most active users for the current week in descending order. Something like userX - 20 posts, userU - 15 posts, userZ - 3 posts. How approximately can this be done? The current week is counted by created_at.

Answer 1

User::withCount(['posts' => function($query) {
         $query->whereDate('created_at', '>=', now()->startOfWeek());
      }])
      ->orderByDesc('posts_count')
      ->take(3)
      ->get();