symfony2 联合查询

1.yml文件

Acme\MspadminBundle\Entity\MspArticle:  type: entity  table: msp_article  manyToOne:    Channel:      targetEntity: MspChannel      inversedBy: Articles      joinColumn:        name: channel_id        referencedColumnName: channel_id    User:      targetEntity: MspUser      inversedBy: Userone      joinColumn:        name: user_id        referencedColumnName: user_id  

 

Acme\MspadminBundle\Entity\MspChannel:  type: entity  table: msp_channel  oneToMany:      Articles:        targetEntity: MspArticle        mappedBy: Channel

 

Acme\MspadminBundle\Entity\MspUser:  type: entity  table: msp_user  oneToMany:      Userone:        targetEntity: MspArticle        mappedBy: User

 

 $sql="SELECT a.id,a.checkStatus,a.title,a.releaseSysDate,                    a.visitTotal,u.userName ,n.name FROM AcmeMspadminBundle:MspArticle a                     JOIN a.User u JOIN a.Channel n";

 

$query = $emt->createQuery($sql." Where a.checkStatus = 0 ");

 

$mspArtile = $query->getResult();