update pad_menu_module_detail set menuName=b.name,categoryId=b.categoryId,categoryName=c.name from menu b inner join pad_menu_module_detail a on b.id=a.menuId inner join category c on b.categoryId=c.id