How to get particular user group price

How to get particular user group price

Joomshopping Addons: Product price for User Group

Hi. How to get specific user group price using code? It's not stored in default product object and getPrice function calculates in regards of current user's group. Task is pretty simple tho - I want to list every prices on the product page that listed in backend.

---

Aw: How to get particular user group price

Price saved in table
xxx_jshopping_products_prices_group


$query = "select * from `#__jshopping_products_prices_group` where `product_id`=".$product_id;
$db->setQuery($query);
$_rows = $db->loadObjectList();
$prices = array();
foreach($_rows as $v){
$prices[$v->group_id] = $v->price;
}

---

Aw: How to get particular user group price

Thanks.

Aw: How to get particular user group price

How do I use this code?