Implements the functionality of getting tree data from a database with one-to-one and one-to-many relationships using only one select-query to the database with flexible conditions configuration.
QueryRelationManager can be integrated with any ORM system based on PHP and potentially compatible with any relational DBMS.
Current package includes an example of integration with raw PDO without ORM.
Also there is an implementation for ActiveRecord as extension for Yii2.
composer require smoren/query-relation-manager