Mysql Insert from another table and count records

I want to to how many 'users' will be inserted into 'ladder'

Thats what i got:

INSERT INTO ladder (id, text, createdAt)
    SELECT id, text, createdAt
    FROM users
    WHERE invisible=0
    AND createdAt >= $today
    LIMIT $maxValue

Thanks for help:)