Index: iknow-api/Repository/Implementations/UserRepository.cs
===================================================================
--- iknow-api/Repository/Implementations/UserRepository.cs	(revision f0fc386e116e253982a713c3b986c26be3ab86fb)
+++ iknow-api/Repository/Implementations/UserRepository.cs	(revision 39f76a913d87c2aaad3ab3e11cb09f9857de636e)
@@ -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 f0fc386e116e253982a713c3b986c26be3ab86fb)
+++ iknow-api/Repository/Interface/IUserRepository.cs	(revision 39f76a913d87c2aaad3ab3e11cb09f9857de636e)
@@ -12,4 +12,5 @@
         Task<int> GetUsersCountAsync();
         Task<User?> GetUserByIdAsync(int id);
+        Task<List<EnrolledSemesters>?> GetUserSemestersAsync(int id);
         Task<User?> GetOnlyUserByIdAsync(int id);