Get all users who are "x" distance away from a given point

I have a large database of users with their locations (Latitude & Longitude). I want to determine which users are "x" km from another reference point. 

Can someone also help me with the correct database design (MySQL)?