Join in Laravel – MySQL

Please note:

Dont forget to mention Facade DB on top as shown in following code:

use Illuminate\Support\Facades\DB;

$gallery = DB::table('galleries')
                        ->join('categories','galleries.category_id','=','categories.id')
                        ->where('categories.status','=',1)
                        ->where('galleries.status','=',1)
                        ->select('galleries.*')
                        ->get();