Get instance_id and location_code woocommerce

<?php 
global $wpdb;
$location_zone = $wpdb->get_results( 
	"
	SELECT {$wpdb->prefix}woocommerce_shipping_zone_locations.location_code, {$wpdb->prefix}woocommerce_shipping_zone_methods.instance_id 
	FROM {$wpdb->prefix}woocommerce_shipping_zone_locations
	INNER JOIN {$wpdb->prefix}woocommerce_shipping_zone_methods
	ON {$wpdb->prefix}woocommerce_shipping_zone_locations.zone_id = {$wpdb->prefix}woocommerce_shipping_zone_methods.zone_id
	"
, ARRAY_A );

echo "<pre>";
print_r($location_zone);
echo "</pre>";
?>