Laravel is a strong php based framework today. Below is a code sample showing how raw query used for join.
$list = DB::table("users AS u") ->join(DB::raw('(SELECT id AS oid,name FROM organization) o'), function($join) { $join->on('o.oid', '=', 'u.organization_id'); }) ->where("o.oid", 15) ->limit(10) ->orderBy("u.id", "DESC") ->select("u.id", "o.oid", "o.name") ->get();