Index: iknow-api/Repository/Implementations/UserRepository.cs
===================================================================
--- iknow-api/Repository/Implementations/UserRepository.cs	(revision c2f79d73d7219c8c8bcc00f5badba27a707b22be)
+++ iknow-api/Repository/Implementations/UserRepository.cs	(revision 691f152bd55c9f383727616f191bbda6ee1abcfb)
@@ -63,4 +63,11 @@
             return await _context.User.CountAsync();
         }
+        public async Task<List<EnrolledSemesters>> GetUserSemestersAsync(int id)
+        {
+            return await _context.EnrolledSemesters
+                .Include(es => es.Major)
+                .Where(es => es.UserId == id)
+                .ToListAsync();
+        }
 
     }
Index: iknow-api/Repository/Interface/IUserRepository.cs
===================================================================
--- iknow-api/Repository/Interface/IUserRepository.cs	(revision c2f79d73d7219c8c8bcc00f5badba27a707b22be)
+++ iknow-api/Repository/Interface/IUserRepository.cs	(revision 691f152bd55c9f383727616f191bbda6ee1abcfb)
@@ -12,4 +12,5 @@
         Task<int> GetUsersCountAsync();
         Task<User?> GetUserByIdAsync(int id);
+        Task<List<EnrolledSemesters>?> GetUserSemestersAsync(int id);
         Task<User?> GetOnlyUserByIdAsync(int id);