How to get 2 database tables and display only the 5 latest records? Laravel

I need to get the latest activity from the database and order them by created_at.

There is a database table of orders, which has a shop_id, and there is a database table of collected_birthdays, which also has a shop_id incommon.

How to get the latest orders and collected_birthdays which has the same shop_id and take 5 latest records?

The mission is to display to the user the latest records of the two database tables, in the future, there will be more tables which will I need to display and get the latest 5 records.

Currently I tried joining the tables, but it merges to one and the created_at value stays only from the one table.

from Newest questions tagged laravel-5 - Stack Overflow https://ift.tt/3jyloMY
via IFTTT