How to make LIMIT on the first table?

Question

PHP

Guys, there are two tables, Brands and their cars. One brand has many cars.
How to make LIMIT 0, 2 on Brands table?
So that I can see only two brands and ALL cars for them?

SELECT * 
FROM `brands` t1
LEFT JOIN `auto` t2
ON t2.`id_brand` = t1.`id`
LIMIT 1

Not suitable, because it cuts off the output of the second one.

Answer 1

first select two brands with a simple query and then join this selection to the car table

select * 
from (select ... from brands ... limit 2 ) b 
left join auto ....