$query="SELECT m.itemName, ifnull(i.iname, '') as iname FROM menu m
inner join category c on c.catids = m.catid
left join menuingredients mi on m.id = mi.mid
left join ingredients i on i.iid = mi.iid
where c.catname = 'food'
order by m.itemName, i.iname";