SELECT
    route.idzone, route.z_name
FROM
    tbl_zone AS route
        INNER JOIN
    tbl_zone AS RepArea ON route.idzone_parent = RepArea.idzone
        INNER JOIN
    tbl_zone AS AgencyArea ON RepArea.idzone_parent = AgencyArea.idzone
        INNER JOIN
    tbl_zone AS Team ON AgencyArea.idzone_parent = Team.idzone
WHERE
    Team.z_name = 'Gold Star'