How to combine filters in an online store?

Question

PHP

There are several tables: A large table with products, a table with product groups, a table with categories, and, accordingly, with filters. So, I group the products and after that I pull out the desired group, but you can filter not only by groups, but by the properties that are inherent in any product, such as: color, brand, country of production, new or not, is there a discount or not, so Here, all these properties are in different tables, and in the table with goods there are links to all these properties. So, how to competently combine these filters with filtering by groups?