How to select records and two more records to them in mysql?

Question

MySQL

There are 2 tables: sources and articles .
You need to select 4 entries from sources and 2 entries from articles for them .
I make 1 request at once: And the second one in each iteration of the loop:
SELECT * FROM sources ORDER BY id DESC LIMIT 4

SELECT * FROM articles WHERE source_id='$id' ORDER BY id DESC LIMIT 2

Is it possible to somehow organize all this in one request?

Answer 1

Subquery?

SELECT * FROM articles WHERE source_id IN (SELECT * FROM sources ORDER BY id DESC LIMIT 4) ORDER BY id DESC LIMIT 2