Tuesday, April 11, 2017

Why leftjoin not working on the laravel eloquent?

I use this package : https://github.com/jenssegers/laravel-mongodb

My laravel eloquent is like this :

$data= User::leftJoin('stores', 'stores.user_id', '=', 'users.id')
             ->select('*', 'stores.name AS store_name')
             ->where('status', '=', $status)
             ->where('users.deleted_at', '=', null)
             ->orderBy('users.id')
             ->get();

I use join to get store name

I try like that, but when I dd($data), there is no exist store name

How can I solve it?



via samuel toh

Advertisement