PHP mysqli.在一个表之后执行SELECT命令，但是从另一个表中选择数据

PHP mysqli. ORDER SELECT after one table but SELECT data from another table?

pageID
visitorID
last_visit

userID(this ID and the pageID and visitorID in visitors is bundled to the same exact user)
username
age

我想选择当前登录用户(ORDER BY last_visit LIMIT 5 in the table visits)的最后5个访问者我想从这5个用户的表用户中选择数据。(用户名，年龄等)

使用JOIN和子查询获取最近5个访问者。

SELECT u.*
FROM users AS u
JOIN (SELECT visitorId
      FROM visitors AS v
      WHERE v.pageID = $currentUserID
      ORDER BY last_visit
      LIMIT 5) AS v1
ON u.userID = v1.visitorID