SELECT COUNT(p.postid) AS numposts, u.* FROM bmb_posts p LEFT JOIN bmb_users u USING(userid) WHERE p.userid = u.userid AND LIKE '" . $delimiter ."%' GROUP BY userid ORDER BY name ASC LIMIT 0,25
For some reason, if the user doesn't have any posts that reside in bmb_posts (marked by their userid in the table), then it doesn't show up the result.

Any way around this little problem?

EDIT: $delimiter is a letter (a, b, c, etc)