left加入ON条件并选择条件差异

I have three tables {animal, food, animal_food} I have three tables {animal, food, animal_food}