比如users表有username和organization列，articles表有authorName和organization列，能否实现像

SELECT u.*, art.title, art.authorName FROM users u
LEFT JOIN articles art ON art.authorName= u.username AND art.organization = u.organization

这种查询。
比如我有两张表如图：

希望查出来的结果是

[{
	username: 'user1',
	age: 25,
	organization: '0560',
	title: 'article1',
	authorName: 'user1'
}, {
	username: 'user2',
	age: 25,
	organization: '0561',
	title: 'article2',
	authorName: 'user2'
}, {
	username: 'user3',
	age: 30,
	organization: '0562',
	title: null,
	authorName: null
}]