ecshop 订单确认中显示省市地址信息的方法

$sql = "select region_name from ".$GLOBALS['ecs']->table('region') . " where region_id in(".$arr['country'].",".$arr['province'].",". $arr['city'].",".$arr['district'].")";
$address = $GLOBALS['db']->getAll($sql);
foreach($address as $value)
{
$arr['address1'] .= $value['region_name']."-";
}