laravel - Convert Subselect to Eloquent Query -

I have this sub-query that I want to be able to convert to a supernatural query. Can anyone help please?

  $ query = 'SELECT * FROM (' Exit excursion from '' where 'exit_at' order = 0 order by DESC) visits group 'visits' Session_id` ';   
 Thanks   
 
 
 query with a match : Go to  : Select ('visit. *') -> Join (DB :: Raw ('(Exit from `` selection` `Exit'` 0` command `updated_at` DESC,` ID` DESC), '', 'visits.id', '=', ' V2 id ') - & gt; GroupBy (' visits.session_id ') - & gt; Mill ();