Mysql-MySQL Query statement for help

The following table is available: CREATETABLE 'loginlog' ('id' BIGINT (20) UNSIGNEDNOTNULLAUTO_INCREMENT, 'username' VARCHAR (100) DEFAULTNULL, 'operate' VARCHAR (512) DEFAULTNULL, PRIMARYKEY ('id') ENGINEMYISAMAUTO_INCREMENT1DEFAULTCHARSETgbk has a lot of data with the same username in the table... mysqlsql

There are the following tables:
CREATE TABLELoginlog(
IdBIGINT (20) unsigned not null AUTO_INCREMENT,
UsernameVARCHAR (100) default null,
OperateVARCHAR (512) default null,
Primary key (Id)
) ENGINE = MYISAM AUTO_INCREMENT = 1 default charset = gbk

There are a lot of data with the same username in the table, and id is an automatic incremental column;
I hope to use an SQL statement to check the list of usernames + operate of the latest id. the usernames in the results are not repeated. Please help write the SQL statement. thank you!