Check the below query for getting the desired result.

SELECT p.Name, p.Id, p.Food, c.Email, c.Phone FROM people p LEFT JOIN contacts c ON (p.Name = c.Name OR p.Id = c.Id) GROUP BY p.Food Order By p.Food;