With drizzle-orm ^34.1.0 you can get result using $count. In you query, you can including playersCount in extras.

 const players = await trx.query.playerTable.findMany({
      with: {
       posts:true
      },
      extras: {
        playersCount: db.$count(playerTable),
      },
    })