Two techniques for handling recursive relationships in MySQL

Flexible data types with the JSON field

Full-text search with MariaDB