我将如何查询以便显示每个用户最近的位置

How would I write a query to show the latest location for each user similar to how I have show? I've searched around but keep failing to implement it correctly. How would I write a query to show the latest lo