Override ProductSearchQuery with your own table Prestashop 1.7

[Makwod]

Hi,

is it possible to make an override with your own custom table?

I need to make an inner/left join with my custom table 

id_product

Id_group

So i can hide some product for some Users. 

I know is possible to override getProducts in Category.php but with Facet Search is not being called.

There are any example for override ProductSearchQuery ?

Thanks

Edited February 16, 2022 by Makwod (see edit history)

[Ress]

You should make the changes in the Facet Search module, because it deals with product display.