Convert SQL query to Eloquent [Solved]

I need help to convert a complex SQL query into eloquent. I have models for all tables (search & airports) in order to join them with With().

The query is:

"SELECT *, fromTable.iata AS from_airport_iata, toTable.iata AS to_airport_iata
FROM ( SELECT * FROM searches ORDER BY searches.id DESC) AS tmp_table   
LEFT JOIN airports fromTable ON fromTable.id = tmp_table.from_airport_id
LEFT JOIN airports toTable ON toTable.id = tmp_table.to_airport_id
GROUP BY tmp_table.to_airport_id
ORDER BY tmp_table.id DESC"

For now I have the following (obviously not doing what I want yet):

$search = new Search;
$search->with('joinAirportFrom')->with('joinAirportTo')->get();

EDIT: I solved the issue.