Order by not working on nested populate

[Hassan_WaqarButt]

@Hassan_WaqarButt

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

@Paul_Brats Thanks for the explanation