ecshop获取等级价格

$sql2= "SELECT rank_id, IFNULL(mp.user_price, r.discount * $row[shop_price] / 100) AS price, r.rank_name, r.discount " .
    'FROM ' . $GLOBALS['ecs']->table('user_rank') . ' AS r ' .
    'LEFT JOIN ' . $GLOBALS['ecs']->table('member_price') . " AS mp ".
    "ON mp.goods_id = '$row[goods_id]' AND mp.user_rank = r.rank_id " .
    "WHERE r.show_price = 1 OR r.rank_id = '$_SESSION[user_rank]'";
   $res_up = $GLOBALS['db']->query($sql2);
   while ($row_up = $GLOBALS['db']->fetchRow($res_up))
    {
    $goods[$idx]['user_price'][$row_up['rank_id']] = array(
     'rank_name' => htmlspecialchars($row_up['rank_name']),
     'price' => price_format2($row_up['price']*$per,$danwei));
    }