Something

SELECT COUNT(p.post_id) AS num_posts, u.user_id
FROM phpbb_users u
LEFT JOIN phpbb_posts p ON (u.user_id = p.poster_id and p.post_postcount = 1)
GROUP BY u.user_id