CREATE TABLE person (id int(5),name varchar(20),dateofb DATE);
INSERT INTO person VALUE (1,'John','1998-01-12'),(2,'Alex','1978-12-28');
CREATE TABLE zodiak (id int(5),name varchar(20),start DATE, end DATE);
INSERT INTO zodiak VALUE (1,'Lion','0000-12-20','0000-01.20'),(2,'Tiger','0000-12-10','0000-12-25');

SELECT * FROM person p 
       LEFT JOIN zodiak h ON (STR_TO_DATE(CONCAT(MONTH(p.dateofb),'-',DAY(p.dateofb)),'%c-%e')) >=
       (STR_TO_DATE(CONCAT(MONTH(h.start),'-',DAY(h.start)),'%c-%e')) 
       AND (STR_TO_DATE(CONCAT(MONTH(p.dateofb),'-',DAY(p.dateofb)),'%c-%e')) <= 
       (STR_TO_DATE(CONCAT(MONTH(h.end),'-',DAY(h.end)),'%c-%e')) WHERE p.id=2;

2	Alex	1978-12-21	2	Tiger	0000-12-10	0000-12-25