Laravel eloquent - Filtering subquery inside with statement

I just found a solution. Basically, I should apply the filter for city table and then call wit function on the subquery. This code solved my problem:

    $countries = Country::where('code', '=', $code)
 ->with(array('cities' => function ($query) use ($user) {
    $query->where('name', '=', 'San Francisco')->with('details');
    }))->first();

Note that I called with('details') on city only after filter in subquery.

The most straightforward one is using join query:

(new Country)
    ->join('cities', 'cities.id', '=', 'countries.city_id')
    ->join('city_details', 'cities.id', '=', 'city_details.city_id')
    ->where('cities.name', 'TheName')
    ->where('city_details.info', 'info')
    ->select('...');

But the result has only one level. So,

$query = (new Models\Country())
    ->with([
        'cities' => function ($query) {
            $query->where('name', 'xxx')->with([
                'details' => function ($query) {
                    $query->where('info', 'info');
                }
            ]);
        }
    ]);
$result = $query->get()->filter(function ($item) {
    return count($item['cities']);
});

The result gives countries with empty cities. So use Laravel collection to filter in the last.