on nested populate sort isn’t working

[hassan-debug]

Bug report

Required System information

• Node.js version: 20
• Strapi version:4.15
• Database: postgres
• Operating system:macOS
• Is your project Javascript or Typescript: Javascript

Describe the bug

I Have collections of players and clubs which have manyToOne relation
i want to get player by id also populate its club and populate club players sort by fullname
but sort is not working on club players

below is my code

const player = await strapi.db.query("api::player.player").findOne({
     where: {
       $and: [{ slug: { $eq: slug } }, { publishedAt: { $not: null } }],
     },
     populate: {
       ProfilePicture: {
         populate: {
           image: true,
         },
       },
       club: {
         populate: {
           feature_image: { populate: true },
           players: {
             populate: {
               ProfilePicture: {
                 populate: {
                   image: true,
                 },
               },
             },
             sort: ['fullname:asc'],
           },
         },
       },
     },
   });

Response

`{
 "id": 3,
 "fullname": "Babar Azam",
 "height": "5 11",
 "weight": "89",
 "slug": "babar-azam",
 "ProfilePicture": {
   "id": 6,
   "image": {
     "id": 4,
     "name": "babar-azam-img.webp",
     "alternativeText": null,
     "caption": null,
     "width": 640,
     "height": 640,
   }
 },
 "club": {
   "id": 2,
   "name": "Lahore Qalander",
   "description": "Lahore Qalander club",
   "createdAt": "2024-01-12T10:21:37.378Z",
   "updatedAt": "2024-01-12T10:21:37.378Z"
   "players": [
     {
       "id": 3,
       "fullname": "Babar Azam",
       "height": "5 11",
       "weight": "89",
       
     },
     {
       "id": 5,
       "fullname": "Ahmad Hafeez",
       "height": "5 10",
       "weight": "89",
     }
   ]
 }
}`

Steps to reproduce the behavior

1. Go to '...'
2. Click on '....'
3. Scroll down to '....'
4. See error

Expected behavior

``{
  "id": 3,
  "fullname": "Babar Azam",
  "height": "5 11",
  "weight": "89",
  "slug": "babar-azam",
  "ProfilePicture": {
    "id": 6,
    "image": {
      "id": 4,
      "name": "babar-azam-img.webp",
      "alternativeText": null,
      "caption": null,
      "width": 640,
      "height": 640,
    }
  },
  "club": {
    "id": 2,
    "name": "Lahore Qalander",
    "description": "Lahore Qalander club",
    "createdAt": "2024-01-12T10:21:37.378Z",
    "updatedAt": "2024-01-12T10:21:37.378Z"
    "players": [
 
      {
        "id": 5,
        "fullname": "Ahmad Hafeez",
        "height": "5 10",
        "weight": "89",
      }
,     {
        "id": 3,
        "fullname": "Babar Azam",
        "height": "5 11",
        "weight": "89",
        
      },
    ]
  }
}`
`