Laravel, compose query query

You need to make a query to select and group data from 2 tables (Laravel models). Detailed TK in HP