SELECT "am_server"."*" FROM "am_service" LEFT JOIN "am_server" ON "am_service"."plan" = "am_server"."server_group" WHERE "am_service"."uid" = '2' AND "am_server"."server_status" = 1'
用*自动引起来,然后提示SQL语句错误。
$data = $app->db->select('am_service',[
'[>]am_server' => [
'plan' => 'server_group'
]
],
'am_server.*',
[
'AND' => [
'am_service.uid' => getUid(),
'am_server.server_status' => 1
]
]
);