Symfony联合查询
t
h
i
s
−
>
s
c
−
>
c
r
e
a
t
e
Q
u
e
r
y
b
u
i
l
d
e
r
(
)
−
>
s
e
l
e
c
t
(
′
a
.
i
d
,
b
.
i
d
,
b
.
n
a
m
e
′
)
−
>
f
r
o
m
(
′
S
c
h
o
o
l
:
S
c
U
s
e
r
′
,
a
)
−
>
i
n
n
e
r
J
o
i
n
(
′
S
c
h
o
o
l
:
S
c
G
o
o
d
s
′
,
′
b
′
,
′
W
I
T
H
′
,
′
a
.
i
d
=
b
.
u
i
d
′
)
−
>
w
h
e
r
e
(
′
a
.
i
d
=
:
i
d
′
)
−
>
s
e
t
P
a
r
a
m
e
t
e
r
(
′
i
d
′
,
this->sc->createQuerybuilder()->select('a.id,b.id,b.name')->from('School:ScUser',a) ->innerJoin('School:ScGoods','b','WITH','a.id=b.uid') ->where('a.id = :id') ->setParameter('id',
this−>sc−>createQuerybuilder()−>select(′a.id,b.id,b.name′)−>from(′School:ScUser′,a)−>innerJoin(′School:ScGoods′,′b′,′WITH′,′a.id=b.uid′)−>where(′a.id=:id′)−>setParameter(′id′,userid)
->getQuery()->getScalarResult();