How to calculate the total likes of all posts of a user

i need to count users all posts like

```

$post = Post::whereUserId(auth::id())->get('id');

$postlikes = PostLike::wherePostId($post)->count('post_id);


it's work in foreach. but I am looking for some more convenient way

Level 21

Did you try this?

$post = Post::whereUserId(auth::id())->get('id')->count();

Level 3

bro, it counts the only post. I wanna count post likes

Level 21

Sorry didn't see your second example.

Can you post you schema?

Level 3

Try using withCount.

you can read further in here

Please or to participate in this conversation.