Illuminate\Database\Query\Builder->count() not working as expected on a query using group by

[MarkVaughn]

When I create a table that uses joins and group bys the count() function does not return the number of results, here's an example from the sql

select count(*) as aggregate from `account` left join `location` on `account`.`id` = `location`.`account_id` where `account`.`deleted_at` is null group by `account`.`id`

Instead of the number of results it shows the number of locations associated with an account (from the group by)

[taylorotwell]

Maybe try a raw query for now then. Feel free to make pull request fixing the issue.