thinkphp6 zfbreal_auth 和 wxreal_auth 两张表数据字段一样均为 auth_id bigint20 unsigned NOT NULL AUTO_INCREMENT COMMENT 主键 shop_id bigint20 unsigned DEFAULT 0 COMMENT 商户ID unique_id varchar100 CHARACTER SET ut
SELECT * FROM zfbreal_auth a INNER JOIN wxreal_auth b ON a.merch_id = b.merch_id WHERE a.apply_state = 'AUDIT_PASS' AND b.apply_state = 'AUDIT_PASS'
原文地址: https://www.cveoy.top/t/topic/f0Di 著作权归作者所有。请勿转载和采集!