MySQL lat/lng coordinate search

gistfile1.txt

     /**
      * Scope locations near a pair of coordinates
      *
      * @param Builder $query
      * @param float $int
      * @param float $lng
      */
     public function scopeIsNear($query, $lat, $lng)
     {
         $statement = sprintf("id, name, street, locality, region, postal_code, country, website, phone, lat, lng, ( 3959 * acos( cos( radians('%s') ) * cos( radians( lat ) ) * cos( radians( lng ) - radians('%s') ) + sin( radians('%s') ) * sin( radians( lat ) ) ) ) AS distance",
         $lat,
         $lng,
         $lat);

         $query->selectRaw($statement);
     }

     /**
      * Scope locations within a given radius
      *
      * @param Builder $query
      * @param string $column
      * @param int $distance
      */
     public function scopeIsWithinRadius($query, int $radius = 10)
     {
         $query->having('distance', '<', $radius);
     }