SELECT
  n.id,
  comp.business_name,
  addr.id AS address_id,
  city.name AS city_name,
  city.id AS city_id
FROM
  (
    (
      (
        nursery n
        JOIN company comp ON ((comp.id = n.company_id))
      )
      JOIN address addr ON ((addr.id = comp.address_id))
    )
    JOIN city ON ((city.id = addr.city_id))
  );