php - MySQL多表连接

Question

post_info 表包含与单个 ID 匹配的许多行(多边)。我无法在输出中返回多行。

SELECT user.*, post.*, post_info.*, board.* FROM user 
join post ON user.id = post.user_id
join post_info ON post.id = post_info.post_id 
WHERE user.id = 26;

我也不确定如何将我的 board 表写入查询。

用户表:

post_info 表:

张贴表:

Answer 1

这就是将板表写入查询的方式。添加了额外的加入以代表董事会发布关系。

SELECT user.*, post.*, post_info.*, board.* FROM user 
join post ON user.id = post.user_id
join post_info ON post.id = post_info.post_id 
join board ON board.id = post.board_id
WHERE user.id = 26;