Support the ongoing development of Laravel.io →
Laravel Database Eloquent

i wont to make this query :

SELECT w.wilayah, a.penerima
  FROM (
                 SELECT DISTINCT wilayah FROM lokasi
       ) w
  LEFT JOIN (
                SELECT COUNT(*) penerima, kota_kab AS wilayah
                  FROM alamat_penerima
                 GROUP BY kota_kab
       ) a ON w.wilayah = a.wilayah

to laravel query, thanks i hope you can help me

Last updated 3 years ago.
0

Sign in to participate in this thread!

Eventy

Your banner here too?

Azzario Razy azzario Joined 5 Oct 2017

Moderators

We'd like to thank these amazing companies for supporting us

Your logo here?

Laravel.io

The Laravel portal for problem solving, knowledge sharing and community building.

© 2025 Laravel.io - All rights reserved.