есть спасиба мне естестно ) скину мож комуто будет познавательно
$query = "SELECT food.Date, food.Food, food_menue.number
FROM food LEFT JOIN food_menue ON food.Date=food_menue.Date AND food.Food=food_menue.Food WHERE food.Date BETWEEN DATE('" . $dt_from . "') AND ('" . $dt_to . "') AND food_menue.User_id = '0' order by `Date`";