How to write a one-to-many SQL query?

Question

PHP

Good evening, there are 2 tables - company (id, title, descr), company_images (id, company_id, image).
The site displays companies and their photos in each company card.

I can select all the photos of a certain company individually, but the problem is that I need to display several companies on the page at once and several photos of each company (cycle in a cycle). How to do it correctly using php? At the moment, I'm uploading photos using ajax, after all the companies have uploaded.

Answer 1

Decide how you will filter companies. And then join this list with the image table (one query) or make a separate query for each company.

Answer 2

SELECT * FROM company_images WHERE company_id IN (айди компаний через запятую)

Answer 3

For example, like this:

SELECT `c`.`id`, `c`.`title`, `c`.`descr`, `i`.`images`
  FROM `company` AS `c`
  LEFT JOIN (
    SELECT `company_id`, GROUP_CONCAT(`image`) AS `images`
      FROM `company_images`
      GROUP BY `id`
  ) AS `i` ON `i`.`company_id` = `c`.`id`