可以'；t加入php/mysql中的第三个表以获取用户名 - Can't join third table in php/mysql to get user name

Can't join third table in php/mysql to get user name

我有一个连接，我已经完美地工作了。但是，我需要加入第三个名为wp_users的表，以便访问用户显示名称。当我添加第二个联接时，根据我的尝试，我会不断出现各种错误，所以我会寻求帮助。

第三个表wp_users有两列：wp_users.ID，wp_users.display_name

这是我添加第二个加入代码之前的代码，这样我就可以获得结果ID 的显示名称

//Works, but I need to join to wp_users on wp_users.ID to get display_name
$results = $dbh->prepare("select 
stories.ID,
stories.SID,
stories.story_name,
stories.category,
points.ID,
points.PID,
FROM stories
JOIN points ON stories.SID=points.SID
JOIN stories ON wp_users.ID=points.ID
where (points.ID = $user_ID) and (PID = 1)");
$results->execute();

将stories更改为wp_users

JOIN stories ON wp_users.ID=points.ID

至

JOIN wp_users ON wp_users.ID=points.ID
$results = $dbh->prepare("select 
stories.ID,
stories.SID,
stories.story_name,
stories.category,
points.ID,
points.PID,
FROM stories
JOIN points ON stories.SID=points.SID
JOIN wp_users ON wp_users.ID=points.ID
where (points.ID = $user_ID) and (PID = 1)");
$results->execute();