This feature allows administrators to verify users (e.g., confirming they are real people or notable figures) and displays a badge next to their names.

You would need a boolean flag in your user table to track verification status.

CREATE TABLE users (
    id INT PRIMARY KEY AUTO_INCREMENT,
    username VARCHAR(50) NOT NULL,
    email VARCHAR(100) NOT NULL,
    is_verified BOOLEAN DEFAULT FALSE,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);