Counting relationships performance

Tables\Columns\TextColumn::make('users_count')->counts('users');

SELECT `notifications`.*,
  (
    SELECT count(*)
    FROM `users`
      inner join `notification_user` on `users`.`id` = `notification_user`.`user_id`
    WHERE `notifications`.`id` = `notification_user`.`notification_id`
  ) as `users_count`
FROM `notifications`
ORDER BY `created_at` DESC
LIMIT 10 offset 0;

SELECT
  `notifications`.*, 
  COUNT(DISTINCT `notification_user`.`user_id`) AS `users_count`
FROM `notifications`
LEFT JOIN `notification_user` ON `notification_user`.`notification_id` = `notifications`.`id`
GROUP BY `notifications`.`id`
ORDER BY `notifications`.`created_at` DESC
LIMIT 10 
OFFSET 0;