How to make a request (product filter)?

Question

MySQL

Good afternoon. I want to make a product filter myself. Something like this. I managed to make it so that when you click on a certain filter, the desired product is displayed, but I can figure out how to make it so that when you click on one filter and when you click on the second and etc. both were displayed at once.
Who is not difficult to tell how to implement this, or what to read how to understand the essence.
As I understand it, you need to play around with the AND and IN operators