Matching data from 2 table with validation date

@DELE,

users_campaigns_join could be a view or a query (subset of data).  I just used the name to represent the data.

Like below...

PHP Code:

select ucj.id
from users_campaigns_join_view ucj
inner join incomes i on i.id = ucj.id
where i.date = '2018-10-10'