`a`.`id`,
`a`.`admin_user`,
`a`.`nickname`
FROM
`tb_auth_admin_user` AS a
LEFT JOIN `tb_auth_role` `b` ON `a`.`role_id` = `b`.`id`
WHERE
`a`.`admin_user` LIKE '%x%'
AND (
`b`.`is_ba
OR `b`.`is_available` == 1
)
最佳答案
`a`.`id`,
`a`.`admin_user`,
`a`.`nickname`
FROM
`tb_auth_admin_user` AS a
LEFT JOIN `tb_auth_role` `b` ON `a`.`role_id` = `b`.`id`
WHERE
`a`.`admin_user` LIKE '%x%'
AND (
`b`.`is_ba
OR `b`.`is_available` == 1
)