简单帮你写一个，没有测试
DELIMITER $$


CREATE TRIGGER tr_test BEFORE INSERT on yuangong
FOR EACH ROW BEGIN
  set new.yg_log_id = concat(last_insert_id(),new.yg_dep);
END$$

DELIMITER ;