How to count row by two fields and group by id as a subquery in laravel eloquent

Eklenme Tarih 1 hour ago
Active 19
Görüntülenme 89
S

How to count row by two fields and group by id as a subquery in laravel eloquent