DELETE FROM `user` WHERE id NOT IN ( SELECT id FROM ( SELECT min( id ) id FROM `user` GROUP BY username ) t )