左连接 leftJoin
示例:
leftJoin("user_address addr on t.id = addr.user_id")
对应sql
LEFT JOIN user_address addr ON t.id = addr.user_id
自定义数据集
leftJoin("(select * from user_address) addr on t.id = addr.user_id")
对应sql
LEFT JOIN (select * from user_address) addr ON t.id = addr.user_id