创建用户角色映射视图 vw_UserRoleMapping

创建视图 vw_UserRoleMapping as select u.UserID as '用户ID', u.Username as '用户名', u.Password as '密码', u.Email as '邮箱', u.Phone as '电话', ur.RoleID as '角色ID', ur.RoleName as '角色名' from UserRoleMapping urm inner join userb u on u.UserID = urm.UserID inner join UserRole ur on ur.RoleID = urm.RoleID;