SearchController.php

public function searchDatabase(Request $request)
    {
			$query = $request['query'];
            $users = DB::table('users')
                    ->join('infos', 'infos.user_id', '=', 'users.id')
                    ->join('wants', 'wants.user_id', 'LIKE', 'users.id')
                    ->join('skills', 'skills.user_id', '=', 'users.id')
                    ->join('helps', 'helps.user_id', '=', 'users.id')
                    ->orWhere('users.first_name','LIKE', "%$query%")
                    ->orWhere('users.last_name','LIKE', "%$query%")
                    ->orWhere('users.email','LIKE', "%$query%")
                    ->orWhere('infos.bio', 'LIKE', "%$query%")
                    ->orWhere('infos.goals', 'LIKE', "%$query%")
                    ->orWhere('infos.doing_now', 'LIKE', "%$query%")
                    ->orWhere('wants.want', 'LIKE', "%$query%")
                    ->orWhere('skills.skill', 'LIKE', "%$query%")
                    ->orWhere('helps.help', 'LIKE', "%$query%")
                    ->paginate(10);

            return View::make('pages.filter',compact('users'));

    }