I had not noticed in your query the use of forum_id. This column has nothing to do with the users, persons and parties tables.

If your objective was to find the users posting messages in a specific forum you should use the forum_messages table, but I suggest that you study the data model first.