This shouldn't require denormalization. `SELECT COUNT(*)` ought to be very fast if you have a foreign key index.