查询重复数据group by menu_id having count(menu_id)>1

select * from sys_power_menu WHERE menu_id in ( select menu_id from sys_power_menu group by menu_id having count(menu_id)>1);

select menu_id from sys_power_menu group by menu_id having count(menu_id)>1;