MySQL Subquery in Query Builder

Can someone please explain how to do this in Query Builder:

select *
from (
         select *
         from a_table
     ) a
         inner join another_table at on at.id = a.id;

Obviously greatly simplified.

Level 50

Tried this tool, and it surprisingly worked pretty well. https://sql-to-laravel-builder.herokuapp.com/

DB::table(DB::raw('(select * from a_table) a'))
  ->join(DB::raw('another_table at'),'at.id','=','a.id')
  ->get();

Probably, someone else can explain or provide better solution then this.

Level 15

Thanks.

Getting there.

Please or to participate in this conversation.