join with on laravel code example
Example 1: DB::table('users')->get();
DB::select('SELECT * FROM users WHERE name = ?', array(Input::get('name')));
Example 2: join in laravel
$subCategories = Subcategory::join('categories', 'subcategories.category_id', '=', 'categories.id')
->select('subcategories.*', 'categories.name AS cname')
->orderBy('id', 'desc')
->get();
Example 3: query builder laravel
use Illuminate\Database\Eloquent\Builder;
public function scopeFakePersons(Builder $query): Builder
{
return $query->where('is_fake', 1);
}