Count the number of results from a relationship in Laravel
Example How to count the number of results from a relationship in Laravel
If you want to count the number of results from a relationship without actually loading them you may use the withCount
method, which will place a {relation}_count
column on your resulting models. For example:
$posts = App\Models\Post::withCount('comments')->get();
foreach ($posts as $post) {
echo $post->comments_count;
}