The table prefix is automatically applied so you can just put "users" as the first argument. Argument two is the column name, and the final is the definition. Therefore:
$db->add_column("users", "rank", "VARCHAR(120) NOT NULL");