id  post_id   createdAt
1   10        0000-00-00 00:00:00
2   12        0000-00-00 00:00:00
3   13        0000-00-00 00:00:00

id  user_id   createdAt
10  62        0000-00-00 00:00:00
12  4         0000-00-00 00:00:00
13  4         0000-00-00 00:00:00

// Get total likes an autor has received
$queryBuilder->select('count(p)')
    ->from('DbEntityAction', 'a')
    ->leftJoin('p.post', 'p')
    ->where('p.user = :user')
    ->setParameter('user', $targetUser);
$totalLikes = $queryBuilder->getQuery()->getSingleScalarResult();

{
  "total_likes": "2"
}