SELECT *
FROM users
JOIN posts ON posts.post_id = ANY(users.user_ids);