How to access other table field in create trigger?

Question

I have two table that relationship. member and setting. setting foreign key to member with member_id field. the question i want to access field in setting. i want to trigger event when member already delete it will chain to delete everything in setting.

Member table -> member_id int

Setting table -> member_id int

CREATE TRIGGER `pandora`.`member_BEFORE_DELETE` BEFORE DELETE ON `member`
    FOR EACH ROW
    BEGIN
        DELETE FROM `setting` WHERE OLD.member_id = @member_id;
    END;