laravel query builder join query as table code example

Example 1: DB::table('users')->get();

DB::select('SELECT * FROM users WHERE name = ?', array(Input::get('name')));

Example 2: DB::table('users')->get();

DB::table('users')->where('name', Input::get('name'))->get();