Personalization question

SELECT DISTINCT o.order_user_id, u.user_cms_id FROM #__hikashop_order AS o
LEFT JOIN #__hikashop_order_product AS op ON o.order_id = op.order_id
LEFT JOIN #__hikashop_user AS u ON o.order_user_id = u.user_id
WHERE op.product_id = YOUR_PRODUCT_ID AND (o.order_status = 'confirmed' OR o.order_status = 'shipped')

<?php
$user = JFactory::getUser();
$userId = $user->get('id');
$db = JFactory::getDbo();
$query = "SELECT op.product_id FROM #__hikashop_user AS u LEFT JOIN #__hikashop_order AS o ON u.user_id=o.order_user_id LEFT JOIN #__hikashop_order_product AS op ON o.order_id=op.order_id WHERE u.user_cms_id=".(int)$userId." AND op.product_id = product_id AND (o.order_status = 'confirmed' OR o.order_status = 'shipped')";
$db->setQuery($query);
$product_ids = $db->loadResult();

$user_id = hikashop_loadUser();
$db = JFactory::getDbo();
$query = 'SELECT `order_id` FROM ' .  hikashop_table('order') . ' WHERE `order_user_id` = '. $user_id .' AND `order_type` = \'sale\' ORDER BY `order_created` DESC';
$db->setQuery($query);
$order_ids = $db->loadColumn();

$orders = array();
$product_ids = array();

foreach($order_ids as $order_id) {
  $orderClass = hikashop_get('class.order');
  $orders[$order_id] = $orderClass->loadFullOrder($order_id, true);
  foreach($orders[$order_id]->products as $product) {
    $product_ids[] = (int)$product->product_id;
  }
}
foreach ($orders as $key => $order) {
  $userClass = hikashop_get('class.user');
  $hika_user = $userClass->get($order->order_user_id);
  $id = $hika_user->user_cms_id;
  $user = ES::user($id);
  var_dump($id);
}
?>

<?php
$product_id = (int)$this->element->product_id;
$db = JFactory::getDbo();
$query = "SELECT DISTINCT o.order_user_id, u.user_cms_id FROM #__hikashop_order AS o
LEFT JOIN #__hikashop_order_product AS op ON o.order_id = op.order_id
LEFT JOIN #__hikashop_user AS u ON o.order_user_id = u.user_id
WHERE op.product_id = '.$product_id.' AND (o.order_status = 'confirmed' OR o.order_status = 'shipped')";
$db->setQuery($query);
$users_ids = $db->loadColumn();
foreach ($users_ids as $users) {
	$userClass = hikashop_get('class.user');
	$users_id = $userClass->get($users);
	$id = $users_id->user_cms_id;
	$user = ES::user($id);
	var_dump($user->name);
}
?>