CODE EXAMPLE FOR PHP

laravel query builder

use IlluminateSupportFacadesDB;

$users = DB::table('users') // Table name

->get() //Get all users

->where('name', 'John') // Where clause

->first() //First result

->groupBy('status') //Grouping