php字段查询坐标并排序

   public function getGoodsField($lat, $lng)
    {
        $field = "goods_id,goods_name,name,commission,ishot,goodsstock,goods_sort,
            small_title,freight,label_id,store_id,line_price,
            normalprice,shopprice,memberprice,
            score,volume,rebuy,goods_img,goodsvideo,zttype,ROUND(
                    6378.138 * 2 * ASIN(
                        SQRT(
                            POW(
                                SIN(
                                    (
                                        " . $lat . " * PI() / 180 - b.latitude * PI() / 180
                                    ) / 2
                                ),
                                2
                            ) + COS(" . $lat . " * PI() / 180) * COS(b.latitude * PI() / 180) * POW(
                                SIN(
                                    (
                                        " . $lng . " * PI() / 180 - b.longitude * PI() / 180
                                    ) / 2
                                ),
                                2
                            )
                        )
                    ) * 1000
                ) AS distance";
        return $field;
    }