स्मॉल स्वूले डीबी 2.3 लेफ्ट जॉइन पेश करता है:

$selector = (new TableSelector('user'))
    ->leftJoin('post', 'messageOwner', 'message')
;

$selector->where()
    ->firstCondition(new Condition(
        new ConditionElement(ConditionElementType::var, 'name', 'user'),
        ConditionOperator::equal,
        new ConditionElement(ConditionElementType::const, 'john')
    ))->andCondition(new Condition(
        new ConditionElement(ConditionElementType::var, 'subject', 'message'),
        ConditionOperator::like,
        new ConditionElement(ConditionElementType::const, '%hiring%')
    ))
;

पैकेजिस्ट: https://packagist.org/packages/small/swoole-db
गिट: https://git.small-project.dev/lib/small-swoole-db