//原生
n
a
v
b
a
r
=
D
b
:
:
q
u
e
r
y
(
"
S
E
L
E
C
T
∗
F
R
O
M
‘
m
c
m
e
n
u
t
y
p
e
‘
m
t
L
E
F
T
J
O
I
N
m
c
m
e
n
u
m
o
n
m
.
m
e
n
u
t
y
p
e
i
d
=
m
t
.
i
d
W
H
E
R
E
m
.
m
e
n
u
i
d
=
navbar = Db::query("SELECT * FROM `mc_menu_type` mt LEFT JOIN mc_menu m on m.menu_type_id = mt.id WHERE m.menu_id=
navbar=Db::query("SELECT∗FROM‘mcmenutype‘mtLEFTJOINmcmenumonm.menutypeid=mt.idWHEREm.menuid=id");
//tp5
n
a
v
b
a
r
=
D
b
:
:
t
a
b
l
e
(
′
m
c
m
e
n
u
′
)
−
>
a
l
i
a
s
(
′
a
′
)
−
>
j
o
i
n
(
′
m
c
m
e
n
u
t
y
p
e
b
′
,
′
a
.
m
e
n
u
t
y
p
e
i
d
=
b
.
i
d
′
,
′
L
E
F
T
′
)
−
>
w
h
e
r
e
(
′
a
.
m
e
n
u
i
d
′
,
navbar = Db::table('mc_menu') ->alias('a') ->join('mc_menu_type b','a.menu_type_id = b.id','LEFT') ->where('a.menu_id',
navbar=Db::table(′mcmenu′)−>alias(′a′)−>join(′mcmenutypeb′,′a.menutypeid=b.id′,′LEFT′)−>where(′a.menuid′,id)
->find();