Laravel select with count(*) using db raw example

January 2, 2018 | Category : MySQL Laravel PHP

Hi Guys,

In this small article. i will let you know how to use select with count aggregate and group by using db raw in Laravel application. Here i gave you simple query example for join with count(*) as aggregate in select statement, i convert it into laravel db query builder.

If you want to use count aggregate function in select statement then you require to use db::raw in eloquent select function in Laravel 5 application. If you write query in SQL then it is very easy to write as like bellow:

SQL Query:

SELECT,, COUNT(click.*) as count_click



INNER JOIN click ON click.user_id =


As we write above sql query, we have to convert it into laravel db query. It's not any default provided query in laravel. But we can use it by using DB::raw. So let's see bellow example.

DB Query:

$data = DB::table("users")

->select("", "", DB::raw("COUNT(click.*) as count_click"))





As you can see above, i convert sql into db raw query as like above.

I hope you found your best solution....