Welcome! You want to display number of products in each category and for each filtering option, do not show empty.
- Mysql database
The filter parameters are known (price, color, style, brand, pattern, composition, size)
- EAV use would not be desirable, because parameters are not planned to be added
We have the following dB structure
The suitability of this structure for this task? As for orm to make a query for fetching the data?