Business has the following requirements, needs to find out at the same time post and post is the user's status (whether collection, thumb up, etc.), don't know how to query is good.
This is the database structure.

This is the use of query.

The question now is, if the user ID (much) for the newly created users do not check in postStateList, postStateList the thread ID listed in the table is not detected.
Like this:

My postStateList table data is as follows:

Please ask next everybody how to modify the SQL statement to find out the desired effect.