//App/Entity/UserSession
<?php

declare(strict_types=1);

namespace App\Entity;

use App\Repository\UserSessionRepository;
use Symfony\Bundle\SecurityBundle\UserSession\UserSessionInterface;
use Doctrine\DBAL\Types\Types;
use Doctrine\ORM\Mapping as ORM;
use LogicException;
use Symfony\Component\Security\Core\User\UserInterface;

#[ORM\Entity(repositoryClass: UserSessionRepository::class)]
#[ORM\Table(name: 'users__sessions')]
class UserSession implements UserSessionInterface
{
    public function __construct(
        #[ORM\Id] #[ORM\Column] #[ORM\GeneratedValue(strategy: 'NONE')] public string $id,
        #[ORM\ManyToOne(targetEntity: User::class, fetch: 'EAGER', inversedBy: 'sessions')]
        #[ORM\JoinColumn(nullable: true)]
        public null|UserInterface $user,
        #[ORM\Column(type: Types::BLOB)] public $data,
        #[ORM\Column(type: Types::INTEGER)] public int $lifetime,
        #[ORM\Column(type: Types::INTEGER)] public int $time,
    ) {
    }

    public function getId(): string
    {
        return $this->id;
    }

    public function getData()
    {
        return $this->data;
    }

    public function setData(string $data): void
    {
        $this->data = $data;
    }

    public function getLifetime(): int
    {
        return $this->lifetime;
    }

    public function setLifetime(int $lifetime): void
    {
        $this->lifetime = $lifetime;
    }

    public function getTime(): int
    {
        return $this->time;
    }

    public function getUser(): ?UserInterface
    {
        return $this->user;
    }

    public function setUser(UserInterface $user): void
    {
        if ($this->user !== null) {
            throw new LogicException('User already set.');
        }
        $this->user = $user;
    }
}

// App\Repository\UserSessionRepository
<?php

declare(strict_types=1);

namespace App\Repository;

use App\Entity\UserSession;
use Symfony\Bundle\SecurityBundle\UserSession\UserSessionInterface;
use Symfony\Bundle\SecurityBundle\UserSession\UserSessionRepositoryInterface;
use Doctrine\Bundle\DoctrineBundle\Repository\ServiceEntityRepository;
use Doctrine\Persistence\ManagerRegistry;
use Psr\Clock\ClockInterface;
use Symfony\Component\Security\Core\User\UserInterface;

/**
 * @extends ServiceEntityRepository<UserSession>
 *
 * @method UserSession|null find($id, $lockMode = null, $lockVersion = null)
 * @method UserSession|null findOneBy(array $criteria, array $orderBy = null)
 * @method UserSession[]    findAll()
 * @method UserSession[]    findBy(array $criteria, array $orderBy = null, $limit = null, $offset = null)
 */
final class UserSessionRepository extends ServiceEntityRepository implements UserSessionRepositoryInterface
{
    public function __construct(
        ManagerRegistry $registry,
        private readonly ClockInterface $clock
    ) {
        parent::__construct($registry, UserSession::class);
    }

    public function save(UserSessionInterface $userSession): void
    {
        $this->getEntityManager()
            ->persist($userSession);

        $this->getEntityManager()
            ->flush();
    }

    public function remove(UserSessionInterface $userSession): void
    {
        $this->getEntityManager()
            ->remove($userSession);

        $this->getEntityManager()
            ->flush();
    }

    public function findOneById(string $sessionId): ?UserSessionInterface
    {
        return $this->findOneBy([
            'id' => $sessionId,
        ]);
    }

    public function removeExpired(): void
    {
        $this->createQueryBuilder('user_session')
            ->delete()
            ->where('user_session.lifetime < :currentTime')
            ->setParameter('currentTime', $this->clock->now()->getTimestamp())
            ->getQuery()
            ->execute()
        ;
    }

    public function create(string $sessionId, string $data, int $maxLifetime, int $getTimestamp): UserSessionInterface
    {
        return new UserSession($sessionId, null, $data, $maxLifetime, $getTimestamp);
    }

    /**
     * @return array<UserSessionInterface>
     */
    public function findAllUserSessions(UserInterface $user): array
    {
        return $this->createQueryBuilder('user_session')
            ->where('user_session.user = :user')
            ->setParameter('user', $user)
            ->getQuery()
            ->execute()
        ;
    }
}