OpenCart 🇺🇦

$order = array();

$result = $this->db->query("SELECT amazon_order_id FROM " . DB_PREFIX . "order_amazon WHERE order_id = " . (int)$order_id);

if ($result->num_rows) {
	$order['amazon_order_id'] = $result->row['amazon_order_id'];

	$order['products'] = array();

	$results = $this->db->query("SELECT oap.order_product_id, amazon_order_item_code, op.quantity FROM " . DB_PREFIX . "order_amazon_product oap JOIN " . DB_PREFIX . "order_product op USING(order_product_id) WHERE order_id = " . (int)$order_id . "
	")->rows;

	foreach ($results as $result) {
		$order['products'][$result['order_product_id']] = array(
			'amazon_order_item_code' => $result['amazon_order_item_code'],
			'quantity' => $result['quantity'],
		);
	}
}

return $order;