users

select
    u.username,
    u.first_name,
    u.last_name,
    u.middle_name,
    c.full_name,
    c.inn
from users u
join contragents c on u.contragent_id=c.id
Where u.active is true
and u.date_added::date = CURRENT_DATE