select id, start_date, end_date
from usr_reservation
where date(start_date) <= now()
and date(end_date) >= now()