SELECT
    enquete_settings.hoikuen_id,
    enquete_settings.start_date,
    enquete_settings.end_date,
    enquete_hoikuens.houjin_name,
    enquete_hoikuens.hoikuen_name,
    enquete_hoikuens.enquete_mail
FROM
    enquete_settings
    JOIN
        enquete_hoikuens
    ON  enquete_hoikuens.hoikuen_id = enquete_settings.hoikuen_id
WHERE
    enquete_settings.`year` = '%s'
AND start_date < CURRENT_DATE
AND end_date >= CURRENT_DATE
AND enquete_settings.mail_delivery = 1
AND enquete_settings.deleted_at IS NULL
AND enquete_hoikuens.deleted_at IS NULL
;