SELECT
    s.staff_id,
    s.staff_name
FROM
    staff_tb s 
    JOIN cultivate_tb c ON s.staff_id=c.staff_id
WHERE
    c.course LIKE '%course3%'
ORDER BY
    s.staff_id ASC

LIKE + 通配符 %,匹配字段