Your attempt wasn’t that bad. You have to do it with LIKE, yes.
In the manual it says:
Use LIKE to create an empty table based on the definition of another
table, including any column attributes and indexes defined in the
original table.
So you do:
CREATE TABLE New_Users LIKE Old_Users;
Then you insert with
INSERT INTO New_Users SELECT * FROM Old_Users GROUP BY ID;
But you can not do it in one statement.