John,
acts_as_mappable is not an association, it's a custom macro and it doesn't support :through option.
So remove it from the User model. And to find all users near some point use something like:
Location.find_within(500. :origin => ..., :include => :user).map (&:user).uniq
Dmitry
