id | username | ... |
----------------------
 1  | name1cat | ... |
 2  |    cat   | ... |
 3  |   name4  | ... |
 4  |   test   | ... |

id | product_name | user_id |  end_date  | active |
---------------------------------------------------
 1 |    good cat  |    1    | 2019-07-15 |   t    |
 2 |    good dog  |    4    | 2019-07-20 |   t    |
 3 |      cat     |    3    | 2019-07-20 |   t    |
 4 |   good phone |    2    | 2019-07-20 |   f    |

SELECT P.PRODUCT_ID, P.PRODUCT_NAME, U.USER_ID
FROM PRODUCTS AS P
LEFT JOIN USERS AS U ON (U.USER_ID = P.USER_ID)
WHERE
P.ACTIVE = TRUE
AND P.END_DATE >= NOW()
AND LOWER(P.PRODUCT_NAME) LIKE LOWER('%cat%') OR LOWER(U.USERNAME) LIKE LOWER('%cat%')
GROUP BY P.PRODUCT_ID, U.USER_ID

id | product_name | user_id | PRODUCT_NAME |  end_date  | active |
------------------------------------------------------------------
 1 |      cat     |    3    |     name4    | 2019-07-20 |   t    |