laravel raw query on joins table with where clause code example

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

DB::select('SELECT * FROM users WHERE name = "'.Input::get('name').'"');