SELECT a.*, b.s_name FROM g_sw a INNER JOIN g_sh b ON a.`s_id`= b.id WHERE a.`id`='73ff7a1a42e3'; 结果: