gistfile1.txt

/**
 * @ORM\Table(name="users")
 * @ORM\Entity(repositoryClass="UserRepository")
 */
class User
{
    /**
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="IDENTITY")
     * @ORM\Column(type="integer")
     */
    protected $id;

    /**
     * @ORM\Column()
     */
    protected $name;

    /**
    * @ORM\OneToMany(targetEntity="Address", mappedBy="user")
    */
    protected $addresses;
}

/**
 * @ORM\Table(name="users_address")
 * @ORM\Entity()
 */
class Address
{
    /**
     * @ORM\Id
     * @ORM\GeneratedValue(strategy="IDENTITY")
     * @ORM\Column(type="integer")
     */
    protected $id;

    /**
    * @ORM\ManyToOne(targetEntity="User", inversedBy="addresses")
    * @ORM\JoinColumn(name="user_id", referencedColumnName="id")
    */
    protected $user;
}

gistfile2.txt

class UserRepository extends ServiceEntityRepository
{
    public function getUsersWithAddresses()
    {
        return $this->createQueryBuilder('u')
            ->select(['u', 'a'])
            ->join('u.addresses', 'a')
            ->getQuery()
            ->getResult()
        ;
    }
}