sql语句 一个表 用户产生两条不同类型的数据 拼接成一条数据

CREATE TABLE `exp1_profit_alloc_c03` (
  `pc03id` bigint(20) NOT NULL AUTO_INCREMENT,
  `uid` bigint(20) DEFAULT NULL COMMENT '用户id',
  `settleDate` varchar(10) DEFAULT NULL COMMENT '对账日期,yyyyMMdd',
  `createTime` datetime DEFAULT NULL COMMENT '创建日期',
  `money` bigint(20) DEFAULT '0' COMMENT '金额',
  `src` varchar(4) DEFAULT NULL COMMENT '0:从消费者，1：从商家',
  `fhb` bigint(20) DEFAULT '0',
  `fhje` bigint(20) DEFAULT '0',
  `syfhje` bigint(20) DEFAULT '0',
  `dcbrfhje` bigint(20) DEFAULT '0' COMMENT '单次本日交易产生返还金额',
  PRIMARY KEY (`pc03id`),
  KEY `settleDate` (`settleDate`),
  KEY `uid` (`uid`)
) ENGINE=InnoDB AUTO_INCREMENT=218033 DEFAULT CHARSET=utf8;

"140285" "1758" "2017-04-18" "2017/5/19 17:34:44" "0" "0" "100" "0" "0" "0"
"141308" "1758" "2017-04-18" "2017/5/19 17:34:44" "0" "1" "100" "0" "0" "0"
"142331" "1758" "2017-04-19" "2017/5/19 17:34:52" "0" "0" "100" "0" "0" "0"
"143354" "1758" "2017-04-19" "2017/5/19 17:34:52" "0" "1" "100" "0" "0" "0"
"144377" "1758" "2017-04-20" "2017/5/19 17:34:59" "0" "0" "100" "0" "0" "0"
"145400" "1758" "2017-04-20" "2017/5/19 17:34:59" "0" "1" "100" "0" "0" "0"
"146423" "1758" "2017-04-21" "2017/5/19 17:35:07" "0" "0" "100" "0" "0" "0"
"147446" "1758" "2017-04-21" "2017/5/19 17:35:07" "0" "1" "100" "0" "0" "0"
"148469" "1758" "2017-04-22" "2017/5/19 17:35:18" "0" "0" "100" "0" "0" "0"
"149492" "1758" "2017-04-22" "2017/5/19 17:35:18" "0" "1" "100" "0" "0" "0"
"150515" "1758" "2017-04-23" "2017/5/19 17:35:28" "0" "0" "100" "0" "0" "0"
"151538" "1758" "2017-04-23" "2017/5/19 17:35:28" "0" "1" "100" "0" "0" "0"
"152561" "1758" "2017-04-24" "2017/5/19 17:35:39" "0" "0" "100" "0" "0" "0"
"153584" "1758" "2017-04-24" "2017/5/19 17:35:39" "0" "1" "100" "0" "0" "0"
"154607" "1758" "2017-04-25" "2017/5/19 17:35:50" "0" "0" "100" "0" "0" "0"
"155630" "1758" "2017-04-25" "2017/5/19 17:35:50" "0" "1" "100" "0" "0" "0"
"156653" "1758" "2017-04-26" "2017/5/19 17:36:00" "0" "0" "100" "0" "0" "0"
"157676" "1758" "2017-04-26" "2017/5/19 17:36:00" "0" "1" "100" "0" "0" "0"

SELECT
*
FROM
exp1_profit_alloc_c03 AS c03_0
INNER JOIN exp1_profit_alloc_c03 AS c03_1 ON c03_0.uid = c03_1.uid
AND c03_0.settleDate = c03_1.settleDate
AND c03_1.src = 1
WHERE
c03_0.src = 0 and c03_0.uid=1758 and c03_0.settleDate  = "2017-04-18"