在选择类型Symfony 5中显示相关实体中的特定字段

namespace App\Entity;

use Doctrine\ORM\Mapping as ORM;

/**
 * @ORM\Entity
 */
class User
{
    /**
     * @ORM\Id
     * @ORM\GeneratedValue
     * @ORM\Column(type="integer")
     */
    private $id;

    /**
     * @ORM\Column(type="string", length=255)
     */
    private $username;

    /**
     * @ORM\Column(type="string", length=255)
     */
    private $email;

    /**
     * @ORM\Column(type="string", length=255)
     */
    private $password;

    // Getters and setters...
}

namespace App\Controller;

use Symfony\Bundle\FrameworkBundle\Controller\AbstractController;
use Symfony\Component\HttpFoundation\Response;
use Symfony\Component\Routing\Annotation\Route;
use Doctrine\ORM\EntityManagerInterface;

class UserController extends AbstractController
{
    /**
     * @Route("/users", name="user_list")
     */
    public function userList(EntityManagerInterface $entityManager): Response
    {
        $query = $entityManager->createQuery('SELECT u.username, u.email FROM App\Entity\User u');
        $users = $query->getResult();

        // Render the template with the selected fields
        return $this->render('user/list.html.twig', [
            'users' => $users,
        ]);
    }
}

{% for user in users %}
    <p>{{ user.username }} - {{ user.email }}</p>
{% endfor %}