write a sql query in laravel

I am trying to convert this sql query in laarvel.

select users.id,count(orders_products.user_id),users.referred_by,sum(orders_products.product_price) from users inner join  orders_products  on  users.id=orders_products.user_id group by referred_by;

This Query get me result

+----+--------------------------------+-------------+------------------------------------+
| id | count(orders_products.user_id) | referred_by | sum(orders_products.product_price) |
+----+--------------------------------+-------------+------------------------------------+
| 35 |                              3 | 0           |                                900 |
| 40 |                              2 | 35          |                                600 |
| 45 |                              1 | 36          |                                300 |
| 44 |                              2 | 41          |                                600 |
+----+--------------------------------+-------------+------------------------------------+

please help me right this query in laravel DB Thanks

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/2BlWEQT
via IFTTT