symfony + doctrine help

I am looking for some, I have the following table setup in my test symfony site,

event  
----------  
id
title
description
date

event_signup  
--------------
id
name
event_id

From this I hope you can see that there is a relationship between event and event_signup.

I want to know how I can get the names for the people that have signed to an event, with mysql I would do something similar too,

SELECT('*') FROM event LEFT JOIN 'event_signup' ON event.id = event_signup.e开发者_Go百科vent_id

How could I write in the styl of Doctrine?

---

If you have defined the relationships correctly in your schema file, you would be able to first retrieve the event object you want, then just write $event->getEventSignups() to get the related objects, and call ->getName() on them to get the names.

---

Go here

It looks like this

JobeetAffiliate:
  actAs: { Timestampable: ~ }
  columns:
  url:       { type: string(255), notnull: true }
  email:     { type: string(255), notnull: true, unique: true }
  token:     { type: string(255), notnull: true }
  is_active: { type: boolean, notnull: true, default: 0 }
   relations:
   JobeetCategories:
    class: JobeetCategory
    refClass: JobeetCategoryAffiliate
    local: affiliate_id
    foreign: category_id
    foreignAlias: JobeetAffiliates